Forum Discussion

DenisRochat's avatar
DenisRochat
Qrew Trainee
2 years ago

Automatically Enter Reference ID in Child Table

I have a parent table with only one record named Communication. Record ID# 1. It will always be only one record. When a new record is created in the Opportunities Table from another table the Related ...
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
np  :)
You are overthinking this.

Just make the reference field on the right side of the Relationship be a formula numeric field with a formula which calculates to 1.  The formula is even simpler than Excel,  the formula is just ....

1


------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
DenisRochat's avatar
DenisRochat
Qrew Trainee
2 years ago
Yes - the overthinking is a problem I got.
Thanks a million!

------------------------------
Denis Rochat
------------------------------