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

Table / Form Design help...

P: 1
Hi
i have 2 tables named Roads and Orders.

The Road has over 4K records and the Orders has just over 100. These 2 tables are linked as an Order can have many streets in it.

So, in my Roads table I've set it to show a drop down list of the 100 Orders, associated to particular streets; whihc then places the Order next to a street.

How can I set up a form which show the full list of roads and it gives me the option to select from the list the Orders? Is there some setting in the propoerties?

Please advise. Thank you.
Mar 25 '10 #1
Share this Question
Share on Google+
2 Replies


patjones
Expert 100+
P: 931
Hi -

If you can post the table structure (field names) and a sample of the data from each one that would be helpful. Thanks.

Pat
Mar 25 '10 #2

NeoPa
Expert Mod 15k+
P: 31,489
You've asked for help with something but you haven't shared the information we'd need to answer your question.

How are your tables linked?

What is the logic behind your setup?

How can an order have many streets with just those two tables?
Mar 26 '10 #3

Post your reply

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