Here is my situation:
I have table called 'contact' and it has a field named 'companyid'.
I link this field to the 'companyid' field in a second table called 'destination'. 'Destination' has a field named 'destinationid'.
'Destinationid' is then linked to 'destinationid' in a third table called 'customerdestination'. It has a field named 'customerid'.
'Customerid' is then linked to 'customerid' in a fourth table called 'customer'.
So my logic is for every 'companyid' value there is a corresponding 'destinationid' value and for every 'destinationid' value there is a corresponding 'customerdestinationid' value and for every 'customerdestinationid' value there is a 'customerid' value.
My ultimate goal is to show the 'customerid' that matches the 'companyid' value, but I can only show the 'destinationid' from the second table. Why can't i show the values from the 3rd or 4th table?
I hope all this makes sense. Thanks in advance for any help.
-Scott
I have table called 'contact' and it has a field named 'companyid'.
I link this field to the 'companyid' field in a second table called 'destination'. 'Destination' has a field named 'destinationid'.
'Destinationid' is then linked to 'destinationid' in a third table called 'customerdestination'. It has a field named 'customerid'.
'Customerid' is then linked to 'customerid' in a fourth table called 'customer'.
So my logic is for every 'companyid' value there is a corresponding 'destinationid' value and for every 'destinationid' value there is a corresponding 'customerdestinationid' value and for every 'customerdestinationid' value there is a 'customerid' value.
My ultimate goal is to show the 'customerid' that matches the 'companyid' value, but I can only show the 'destinationid' from the second table. Why can't i show the values from the 3rd or 4th table?
I hope all this makes sense. Thanks in advance for any help.
-Scott