Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating a form with 3 tables

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
I've got to built a form based on many Tables. Knowing that I cannot do it directly from tables, I created a Query that takes all the fields in Customers, Orders, Employees and saved it like that. Then I moved to the form tab and ask the Assistant to build the form automatically... but it does'nt work as I've planed and create errors. All the fields in Orders (except one) display's "#name?". The other fields are ok... but I don't need 'em on the form itself... I only need 'em to have their values to fill the blanks... does any one here ever had to work on a form like that and could show me a way to do it?

Spazm
 
In a relational database, the best way to display information from multiple tables on one form is by using subforms.
 
Subforms are not a feature of relational databases. Joins however are.

Pick what you want from each table and create a query that collects them together meaningfully. If you can't do that then question why you are trying to do what you are trying to do.

Access is very good at handling updates to multiple tables through queries (ie updatable views).

Here is a tip. Try and put on any form only what absolutely needs to go on one form. If you could buy 300 foot monitors some programmers would fill them with 9000 data fields. There is absolutely no point. Update something then press the button and on to the next form. You can have as many forms as you like. It's easy to control flow in this way.

Keep it simple. mike.stephens@bnpparibas.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top