By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,617 Members | 1,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,617 IT Pros & Developers. It's quick & easy.

Multipul record sets in access

P: 16
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???
Oct 5 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
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!
Oct 8 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.