Forum Discussion

AswinBabu's avatar
AswinBabu
Qrew Member
5 years ago

Reference field are not getting automatically selected after importing

I have 2 tables - A & B which I imported from an excel file. A have fields - ShowId(key),  show name, show time B have fields - ActorFirst name, ActorLast name, Phone, ShowId I have made a one ...
Relationships
AswinBabu's avatar
AswinBabu
Qrew Member
5 years ago

I have been looking for that but I'm not able to find how it can be set as a reference field. Please guide me how to make showid as the reference field



------------------------------
Aswin Babu
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

You will need to delete the relationship and then make the relationship again,  but this time select ShowID as the reference field.  You will end up with a left over field called something like [Related Show]  and that can be deleted.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------