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
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago

In Table B, is ShowID the field that is being used as the reference field for the relationship to Table A?



------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
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
    ------------------------------