Forum home » Delegate support and help forum » Microsoft Access Training and help » exce+training - Joining multiple table fields in a single form
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
exce+training - Joining multiple table fields in a single form
Resolved · Low Priority · Version Standard
ReplyJoining 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?
For upcoming training course dates see: Pricing & availability
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.
|