How to add new fields from a second table?

[Brenda]

Please bear with me, as I am a very new user of Access. I am running Access2000.

I have created two simple tables and one form that has fields on the form from the first table.

I have made a relationship between the two tables using the field ID.

How do I add fields to the form, using fields from the second table? My fields are showing up with "#NAME?" which tells me I probably do not have them pathed to the table correctly. How do I fix this?

Sorry to be such a newbie.

 

[Dugantrain]

When you base a form off of two or more tables, you must first create a query based off of those tables. At this point, you can build a form based off of the query. Just go to Queries, Design View, add the two tables, and select which fields you want in the form. As long as your relationship tie makes sense, it should work fine.

 

[Brenda]

One additional question

Thank you VERY much.

One additional question:
If I add a third table, how do I add some fields from that third table to the form?

Do I create then another query? Would that query contain only fields from the third table?

Thank you again,
Brenda

 

[doss]

Hello,

You would add the 3rd table to the query with the first two tables (provided that the 3rd table relates to one of the other tables). Then you would just add whatever fields you need to the query.

Hope that helps.

 

[Brenda]

Thank you

Yes, that helps a lot.

Many thanks to both you and Dugantrain.

~Brenda