Multipul record sets in access

[trogenone]

Hi

I have already had some help from you guys but am still having problems.

I have two tables [Account Information] & [Order Entry] These two tables have a one to many relationship. Account Info has an AutoNumber and the primary key. Order Entry has just an AutoNumber and no key.

What i need access to do is when the order entry form is opened from the switchboard it runs a query that askes for the account number of the client. After entering the AccNo the form is displayed for the order entry. The problem im having is that access isnt attaching the order entry to the account in question. What am i doing wrong???

[PEB]

Hi,

Why don't simply adda combobox in your order form from which the user can choose your account!

Make your combo box bound to the respective field of the table Orders!

Best regards!