How To Add Mulitpul Records To A Single Account

[trogenone]

Hi

I am building a simple accounting and order entry site. I am a basic user in access and need a little help. I have a table [Account details] then another for [Order Entry] but access will only allow me to have one order entry for one account? I want access to use the same account or the one thats entered into the query then be able to add multipul orders to it so as to help build a history of the client? I hope this is making scence to you guys and that maybe you can help stear me around this problem.

Looking forward to your comments

Brian

[PEB]

Hi,

In fact in your table Orders AccountID have to be a foreign key so you need to say for this field that it is indexed but with dublicates!

And I don't see other reason to not accept your orders for multiple accounts!

:)

[trogenone]

Hi,

In fact in your table Orders AccountID have to be a foreign key so you need to say for this field that it is indexed but with dublicates!

And I don't see other reason to not accept your orders for multiple accounts!

:)

Thank you for your help but not sure what you mean Foreign Key? My tables are Client Information And Order Entry which are linked with a relationship of one to one. Could you explain a little more for me?

tahnk you

Brian

[PEB]

So your tables have to be linked one to many coz one account can participate in multiple orders isn't it?

So You need to change your table Orders information and apply for AccountID to be Indexed with DUBLICATES! in the field properties...

Before doing this first remove your relationship between tables... If not You can't change the tables....

After the change - create a relationship it will be One to Many without asking you!

:)

[trogenone]

So your tables have to be linked one to many coz one account can participate in multiple orders isn't it?

So You need to change your table Orders information and apply for AccountID to be Indexed with DUBLICATES! in the field properties...

Before doing this first remove your relationship between tables... If not You can't change the tables....

After the change - create a relationship it will be One to Many without asking you!

:)

Hi
Well that has worked but for one thing. The tables now alow me to input multipul order entrys but it isnt attaching them to the appropriot account. When you enter ORDER ENTRY it asks you for the account number ok. I enter the account number and the ORDER ENTRY screen opens. It allows input and saving but like i said its not attaching the record to the account number requested. Would it be possible to send the DB to you to see what im doing wrong?

Many thanks
Brian

[PEB]

Ok! At vladimir_d@bit. bg