I am attempting to learn Access2000.
I have created two simple tables that both have the field "ID" in them. I have created a relationship between the two tables with this one field.
Using the Access wizard, I have now created a form (my goal) but the form is using only one of the two tables.
My goal is to add fields from the second table to this existing form.
How do I do this? I am unsure how to tell the form that I want to go to the second table and field.
When I move out of design mode, I get #NAME? which tells me I don't have the field linked correctly to the table field..
HELP...
I have created two simple tables that both have the field "ID" in them. I have created a relationship between the two tables with this one field.
Using the Access wizard, I have now created a form (my goal) but the form is using only one of the two tables.
My goal is to add fields from the second table to this existing form.
How do I do this? I am unsure how to tell the form that I want to go to the second table and field.
When I move out of design mode, I get #NAME? which tells me I don't have the field linked correctly to the table field..
HELP...