Adding Existing Data to Records

[LukeJ Innov]

Hello all,



I have a database that has two tables, one for customers (companies) then a second table for contacts of those customers, these tables are linked.
How would I create a form that would allow a user to input contact data to a customer (company).

For instance:
By selecting a company name from a dropdown list, or an option to create a contact and a new customer (company).

Thanks,

Regards,
Luke.J

[RuralGuy]

The Companies table would have a 1:M relationship with the Contacts table so using a Form/SubForm would be the suggested approach with the Contacts in the SubForm.

[LukeJ Innov]

Cool thankyou very much, I have done what you have said, very helpful .

But what would I then do when I want to add new data using the form, would it be possible to add a drop down box that allows for the adding of a new customer then a contact, as well as allows to select an existing customer and add a contact to it?

Sorry to be a pain.

Regards,

[RuralGuy]

How are you looking up existing customers? I would suggest a "New Customer" BUTTON on the MainForm.