I have two different tables. One table uses SS number as a Primary Key and some other information, while the second table uses the same SS number as the primary key and some different information from the first table. I want to add a new record under the same SS number in both tables through a form. How do I do that?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
[red]Update two different tables through one form[/red]
- Thread starter Szigeti
- Start date
Updating 2 tables is done by opening up both tables in VBA and adding records to both.<br>As far a parsing out something use that in the LEFT function to strip out the other part<br><br>SS = Left(WholePrimaryKey, Len(WholePrimaryKey) - Len(OtherData))<br><br>See my FAQ for adding data to more than one table.
- Status
Similar threads
- Locked
- Question
- Locked
- Question