Hi
I like to know haw doI create a form based on multiple tables, all tables are linked.
Some table contains drop down lists, I want all info in all tables dispalyed in the form. Help Please

Recommended Answers

All 2 Replies

You would likely need to use subforms, especially if there are any one-to-many relationships.

You can use the wizard to create the main form from the main table then use the SubForm command button to add a subform from the other tables - the wizard will let you select each different table. The drop-downs should automatically work in the form if they do in the table. At least they alway have for me since '02.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.