Link to home
Start Free TrialLog in
Avatar of noad
noadFlag for United States of America

asked on

Relationships from here to there...

Ok...
I have been at this for some time now, hoping to figure it out, but no joy...
I have a table name Leads, when I input info to the the leads table it writes to the Dealers table and to the Contacts table.
The problem is that when I go into the Dealers table to only see the dealer's info which comes from the Leads table when I fill out the dealers info and the same for the Contact side.
I know what I want to do, but I can't figure it out.

User generated image
Avatar of North2Alaska
North2Alaska
Flag of United States of America image

Were you able to remove the duplicate columns and reduce the data down to just the one table?

From the looks of your diagram, is the leads_id in the Leads table the primary key for the leads table?
Avatar of noad

ASKER

yup

But what I need to be able to do is that when I input data from the Leads table which also create data in the dealers & contacts table...
I want to be able to see from the Dealers side the contact and from that contact the dealers.
ASKER CERTIFIED SOLUTION
Avatar of North2Alaska
North2Alaska
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of noad

ASKER

ASAP...
This week maybe hard due to the 4th...
But I need to correct this tonight, they need to start using it tomorrow.
Any ideas how to get it working
Avatar of JoJohn2004
JoJohn2004

Can you describe how many actual tables you have? Are contacts and dealers in the same table or do you have separate tables for each? Do the colors in your diagram represent different tables? I am going to assume they do.

EVERY path in the relationship graph chain must be valid for the endpoints to see each other. For example, use the topmost chain (Leads ->Dealers->Contacts~dealers). You are on a Leads-based layout and have put a field from the Contacts~dealers relationship on the page. In order for data to display in that field, you must have a Dealer record in the Dealer table whose DealerID in Leads matches one in the Dealer table AND you have to have a contact in the Contacts table whose ContactID in the Dealers table (not the leads table) matches a ContactID in the Contacts table.

This is a very convoluted way to display this data. If there are strong business rules for keeping the Name data in separate fields then do it this way. If not, save yourself a lot of aggravation and put all the Biographical info for all your people in one file.

If you want to send me a clone of your file I can show you what I mean
fmpsolutions@nantucketisle.com

JJ
Avatar of noad

ASKER

JJ

Thank you for your offer, North helped me out with it...