Formula syntax to reference a related table
Hi there, I will preface this post with the fact I'm very new to QuickBase. Day 2, in fact. I have two related tables. In table 1 I have a text field called 'Range covered' In table 2 I have ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhen you say that your tables are "Related" do you mean that there is a Quickbase relationship between the tables.
Also can you take a step back and explain the business purpose of what you are trying to do. It would help us suggest a structure for their tables and their relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Also can you take a step back and explain the business purpose of what you are trying to do. It would help us suggest a structure for their tables and their relationships.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark
Yes there is a QuickBase relationship between the tables.
The business purpose is that the value entered into the related tables may be different, but it could be the same. So, I don't want people to have to replicate the data if it's the same. I want them to indicate if the value is the same in both tables, and for the form for the second table to display the value from the first.
Thanks
------------------------------
Jemma
------------------------------
Yes there is a QuickBase relationship between the tables.
The business purpose is that the value entered into the related tables may be different, but it could be the same. So, I don't want people to have to replicate the data if it's the same. I want them to indicate if the value is the same in both tables, and for the form for the second table to display the value from the first.
Thanks
------------------------------
Jemma
------------------------------