Joining multiple table fields in a single form
I would like to join certain fields from more than one table into a single form to enable data input, whats the best/easiest way to go about this?
RE: Joining multiple table fields in a single form
Answer to the question:
If your tables have an existing relationship which is already created, you can bring the fields together in a query.
To do this you can utilise the Simple Query Wizard or you can Create the New Query manually. If you use the Simple Query Wizard you will be walked through the steps which will enable you to choose your required fields from their respective tables.
However if you use the manual method you must include both (or more) tables from the Show Table dialog box. Bringing the chosen fields onto the Query Design Grid will create the query; once saved and named.
Create a Form from the query, either using the Form Wizard, Manually or AutoForm, the form can if required be set to ADD Mode only which will feed the data to the underlying Tables.
Apart from the Select Query there are a number of other queries which have specific uses and these are all covered on the Access Intermediate course.
