Skip to main content
Question

Reference field are not getting automatically selected after importing

  • December 28, 2020
  • 0 replies
  • 57 views

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 to many relationship between A and B with A as Parent and B as child. A report link was also created to directly see all Actors with each show.  

But I'm not able to see the filtered table B when i click the report link in Table A. I have to manually go to each record and edit the reference. is there a way to automatically add the reference based on the showid which is present in both tables. 



------------------------------
Aswin Babu
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • December 28, 2020

Can you tell us the field name in table B which holds the ShowID, and also in the relationship between One Show has many Actor Performances, what field is used for the Related Show?  I suspect that you let QuickBase create a new field called [Related Show] when in fact you should have built the relationship to use the [ShowlD] field.



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
  • BlakeHarrison
  • Quickbase Alumni
  • December 28, 2020

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/
------------------------------
Terms & ConditionsAccessibility statement