Creating new records using from entries

callumwatson

Registered User.
Local time
Today, 09:15
Joined
Jun 22, 2001
Messages
22
My database aims at holding details about clients enquiring to our company. I have a form named 'Enquiry' which lets the user add an enquiry record in my 'Enquiry' table. I have a field in my form which takes in the company name. What I want to do is automatically create a record for more company details in another table which I have called 'Client'? I already have a relationship between the entities 'Enquiry' and 'Client'(One company can make many enquiries but a single enquiry only relates to one client.)
I'm sure this can be solved very quickly and easily, but as a new access user I don't know how?
 
Okay, your best bet is to create a subform on your main form with the recordsource of Client and link the CompanyName in the master and child links. This way, you can add the company name to both tables and add seperate data for each table. In case you didn't know, the Subform wizard is between the tabular control and the line tool on the toolbar. Click that on your form and a wizard will pop up carrying you through the rest of the process. Hope that helps.

Doug
 
Thanks for your prompt and logical solution. Using the subform allows me to eliminate the duplication of fields between my two tables. I have been trying to use the controlsource box in the properties to make the input from the user update two separate fields at once.
 

Users who are viewing this thread

Back
Top Bottom