Add new records via form

travismp

Registered User.
Local time
Today, 18:34
Joined
Oct 15, 2001
Messages
386
I have 2 tables with a one-to-one relationship.

I want to make a form for entering a new client. "Add New Client" Is there a way to make a form with the various blank fields then when I click "add" it Adds the record to both talbes?

tbl_Account
tbl_History

CompanyID is the PK for each talbe.
 
I found a way if I have both tables in a query on the backend. Then add both PK fields to the form. It will work then, but it looks silly making someone add the [CompanyID] to the form 2 times.
 

Users who are viewing this thread

Back
Top Bottom