I am pretty new at access, but here it goes.
Table 1
-network ID
-Name
-Address
-etc
This table is taken from a pre-existing database and I need to add information to create my own reports.
I have created a form where I can enter the remaining data that I need, this information is stored in table2.
My forms has a network ID field and some other fields that I need to take from Table1 and automatically update when I enter new information into Table1. I would then be able to go in and complete the remaining information to update Table2.
thank you,
Phillip
Table 1
-network ID
-Name
-Address
-etc
This table is taken from a pre-existing database and I need to add information to create my own reports.
I have created a form where I can enter the remaining data that I need, this information is stored in table2.
My forms has a network ID field and some other fields that I need to take from Table1 and automatically update when I enter new information into Table1. I would then be able to go in and complete the remaining information to update Table2.
thank you,
Phillip