I have a table called New Leads, I like populate the first name, Last name, work phone ect.. or to the Contact table.
both the New Leads table and the Contact table have a PK and the contact table also has a FK.
So if I enter a new Lead and I type in the new Leads first name, last name ect.... I also want to make a new contact at the same time.
What I don't want is the opposite, meaning if I start a new contact, I don't want it to start a new lead.
I have tried different things, linking the Pk to Pk / Pk to Fk...
I cant even get it to populate over from the new leads table to the contact table.
How would I go about doing thins???