I am having trouble with a trying to roll fields from multiple tables up into one ""overview"" table.
I have an app with two local tables and two connected tables .The connected tables pull data from a separate QB app.
I want to create a table that incorporates some fields from each of the other 4 tables in the app. Each table I'm working with has a Unique Identifier field. These values are unique in their table but match up to what record they correspond to in the other tables.
The "overview" table I am trying to create has only has the Unique Identifier field populated. I'm able to get one table at a time to relate to the "overview" table, based on a relationship keying on the unique identifier field. But when I try to add a second table's relationship, there is not an option to choose my Unique Identifier field. Quickbase auto populated the reference field with a Related Record choice and the pull-down does not include the unique identifier. Help!
Should I be using Import instead of a relationship? Or what am I doing wrong? Thank you!!
I want to create a table that incorporates some fields from each of the other 4 tables in the app. Each table I'm working with has a Unique Identifier field. These values are unique in their table but match up to what record they correspond to in the other tables.
The "overview" table I am trying to create has only has the Unique Identifier field populated. I'm able to get one table at a time to relate to the "overview" table, based on a relationship keying on the unique identifier field. But when I try to add a second table's relationship, there is not an option to choose my Unique Identifier field. Quickbase auto populated the reference field with a Related Record choice and the pull-down does not include the unique identifier. Help!
Should I be using Import instead of a relationship? Or what am I doing wrong? Thank you!!
