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

relationships and tables

P: 7
I have 2 tables, one table is fixed prices and the other is where I want to store the quantities. I have been trying to create a form with a combo box so when you select a customer number the prices set for that customer will appear. I also need to add a quantity and Total Price field to the form. My problem is I have been trying to base the form off a query. I can not seem to get the query correct. When i select a customer in the query it stores the information back into the table that is for "set prices" instead of the table that stores the quantities.

Any suggestions?
Jan 24 '08 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Looks like you need to use a linked subform on your mainform.

Best to check the Order/OrderDetails in the NorthWind sample .mdb that comes with Access and/or can be downloaded at the Microsoft site.

Nic;o)
Jan 28 '08 #2

Post your reply

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