Multiple table fields on same form

[CaryRW]

I am kind of new at creating complex (multiple table) databases. I am wanting to have fields from multiple tables on the same form. How is this accomplished? I noticed that on the form properties that I could change the database sorce, but I couldn't determine how to choose multiple tables.

Thanks in advance for any help!! Cheers!


Cary

 

[wizcow]

Cary

If you use a 'Form Wizard', the wizard asks you to choose a table or query from a pulldown list. Once you choose the table the wizard asks you to select fields from that table. After you have done that you may choose another table or query.

A more accepted manner of using mulitple tables would be the use of a 'Select Query'.
Just start a select query, then add your tables to the top frame.
Drag your needed fields to the bottom frame.
Then make your form's source be the new query.

Good luck
Tom

 

[CaryRW]

I am not sure I follow you. If I decide to use the Form Wizard approach, do I have to do this before I finish the first time? I have already added the fields from the first table and now want to add the second and third tables fields.

As for the 'Select Query' way, how do I start this? I have searched around a bit and don't seem to find a way to do it. Again, I am fairly new to this... Thanks for the help!!!!


Cary

 

[CaryRW]

Never mind... I was able to figure out what you were talking about. I created the "query" placing all the fields from all the tables. I then chose that query as the data source. All the fields are now showing up in the field chooser, so I have to assume that I have done it right. I haven't tested it yet with data, but I am feeling much more positive.

Thanks for the help!!!!!!


Cary