Relationship
I am trying to connect two tables, both having the same Primary key fields. However, they are not connecting and returning look-up field data. Both of my Primary key fields are Compostie type - is t...
Forum Discussion
No the relationship is returning no data in the fields.
Table1 Primary key is composite field of CustomerID and TrackingID.
Table2 Primary key is composite field of CustomerID and TrackingID.
I want to bring in a field from Table2 called Order Number into Table1. However in my relationship, no data returns.
Thank you,
Alycn Bjergo-Justen
Director of Business Applications & Support
P 888.390.5320
D 651.209.3842
SOLUTIONS MADE SIMPLE.
For one thing you cannot have a formula as a primary key. That is not possible any longer. There used to be a bug that allowed it to be set by API but I believe they fixed that. You can have a MERGE field be a composite field as you call it. That can be used to import data. So it should not be possible at all to do what you have described so far. I didn't understand that you meant you made a formula field when you said composite.
You will need to figure out how your data relates in another way. You can do this in many ways depending on your data. From your forum signature it looks like you are creating something for a shipping company. You could relate everything back to a Contact and have them be the key for everything. That way the contact owns the orders and you can relate things in that way. The contact could be a person or a company. If it is a company you might consider going with both a Company and a Contact table in case you need multiple contacts.
You will need to figure out how your data relates in another way. You can do this in many ways depending on your data. From your forum signature it looks like you are creating something for a shipping company. You could relate everything back to a Contact and have them be the key for everything. That way the contact owns the orders and you can relate things in that way. The contact could be a person or a company. If it is a company you might consider going with both a Company and a Contact table in case you need multiple contacts.