Add table to Form?

[TroutMan]

ACCESS 2003

I created a form through the form wizard using two tables but now want to add a third table.

Is there a way to add additional tables to the form without adding them as subforms??

 

[Norie]

What exactly do you mean?

Does the form use a query based on the 2 tables as it's record source?

 

[TroutMan]

I built a relationship between several tables and then proceded to use the wizard to build a form. The wizard prompted me for the tables (or queries) to use in the form. I selected two of the tables and now want to add another. The online instructions is not making much sense.

 

[TroutMan]

MS Access 2003 on Windows XP

Started from scratch generating another form. Sequence of steps taken to date:

1. Created 7 tables

2. Established relationships (tools > relationships) with all tables using a single primary key; the same value in each table (plate number)

3. Started a form using "form wizard" utilizing the existing tables

4. Halfway through development of the form I needed to add a field to one of the tables. Added field to table and saved.

5. Opened form in "design view" and picked the "field list" tool to select the new field and add it to the form.

The new field is not in the list though the other pre-existing fields contained within the table are in the list.

Why Not??