Forum Discussion
form with fields from multi tables
Hi, i'm trying to create a form that has fields from many tables (employee information table, employee contact table and employee location table) using a form wizard or blank form. i did selected the...
Hi JoeQar ! Tables are only to store the data in MS Access, so i suggest to make a autoform upon your tables. Its very good to have 1-n-Relationships between them. Try this: You can select the (customers, detail) table on the left navigation, then pls. click on "Create" tab - FORM, pic 8 and 9 additionally here. I made a quick tutorial for you in here with a new database, concerning customers and requests in a call center. Requesttable is now the so called Master table, which is nested as a second form INSIDE the main form. Hope you dont mind that a few german labels are in there.
Greets, Eva.
