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?
I'm sure this can be solved very quickly and easily, but as a new access user I don't know how?