troubleshooting Question

Data from one table to another

Avatar of noad
noadFlag for United States of America asked on
FileMaker Pro
11 Comments1 Solution640 ViewsLast Modified:
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???

Thanks :)
Senior Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 11 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros