AlexisEvans
5 years agoQrew Member
table relationships
I am not sure if what I want to do is possible in QuickBase. I am building a database to track the handling of overpayments. That table is the "parent". I hoped to build relationships to two sub-tables. One is for recording actions taken. The second one tracks balance changes. (i.e. the original balance being pursued is $10,000...a month later, it is $9,000). If I were just building the database on a moving forward basis, I don't think I'd have any issue. However, I am trying to import historical data. My relationships don't work because the Record ID in the parent table does not tie to anything in the child tables. I used a formula to concatenate fields and build a true record identifier, but I am unable to use that as the Key since it is a formula. Is there any way to backload data and build the relationships between these tables? Admittedly, I am newer to QuickBase, but so far, the tutorials I've watched don't show the functionality I'm looking for.
------------------------------
A Evans
------------------------------
------------------------------
A Evans
------------------------------