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-ta...
If I'm understanding correctly, you should be able to achieve this by doing a couple of things:
1. Create another field in your table that will be your key field (a data entry field, not a formula) 2. Copy the value of your formula field into this new field for every record - Not sure how much data you have but if small you could do this in grid edit, if you have a lot of data just dump the table out with RID, and import your formula key column into the data entry field 3. change your key to the non formula field 4. On a moving forward basis set up a form rule in that table that on save, copies the value from your formula field to the key field
------------------------------ Charlie Murawski ------------------------------
Hello! Thank you for responding. I was able to make all of the relationships, load my historical data, and see the proper child table data from the records on the parent table. But, now I'm stuck trying to implement step 4 in your response. The formula in the Concatenated ID field calculates as users key in a new overpayment record. I need that formula result to copy into the Deficit Record ID field to become the Key field on the newly added record.
I tried using a Dynamic Rule, but the Deficit Record ID is not populating. Therefore, I receive an error when I try to save the record because the Deficit Record ID is blank (and it is the required Key field). My rule is shown below.
I also tried to set up an automation, but I was unable to select my Concatenated ID from the Select field list shown below. What am I doing wrong?
I'm sorry, but where am I supposed to use that? I cannot find it in any of the available drop downs. If I need to key it somewhere, I don't know where.