Table to Table Relationship Trouble
Hello,
I have 4 tables. Lets say the tables are A, B, C, and D.
The relationships are current set up A->B->C->D each with different key fields
On my C->D relationship Table D is already populated with data and the Key field in C has already been connected via one to many relationship with D. However Table D does not seem to be working with this relationship. The related field is there but the existing data is not taking on the relationship even thought the key field of C and the related field of D are exactly the same. It is only allowing be to create a new record under D which gives option in the reference field to relate back to C. How do I ensure Quickbase works with D's existing data?
I hope all this makes sense lol!
I figure it out thank you ! Not sure how to delete so just editing
Best,
Noel
------------------------------
NOEL HODGES
------------------------------
I have 4 tables. Lets say the tables are A, B, C, and D.
The relationships are current set up A->B->C->D each with different key fields
On my C->D relationship Table D is already populated with data and the Key field in C has already been connected via one to many relationship with D. However Table D does not seem to be working with this relationship. The related field is there but the existing data is not taking on the relationship even thought the key field of C and the related field of D are exactly the same. It is only allowing be to create a new record under D which gives option in the reference field to relate back to C. How do I ensure Quickbase works with D's existing data?
I hope all this makes sense lol!
I figure it out thank you ! Not sure how to delete so just editing
Best,
Noel
------------------------------
NOEL HODGES
------------------------------