I have set up two tables to share the value of country but shared value field is not working. NOthing shows up in the picklist. What am I doing wrong?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Mark

Mark

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBasePros (Laura Thacker)

QuickBasePros (Laura Thacker), Champion

  • 6,396 Points 5k badge 2x thumb
I do not recommend using this feature of QuickBase - as it relies on those choices to already be used in a record in the source table.

Instead, create a table of 'Countries' to which you can build a relationship to each of your tables where this data needs to be selected.  This will also provide you the advantage of better reporting at the Country level; but eliminate the need for a Country multiple choice value to already be assigned to a record in that table where the field exists.

Don't forget to create a record for each country in your new Countries table - having them as multiple choices doesn't mean there's actually a record to choose from.