Automatically Enter Reference ID in Child Table

Question

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 Communication has to be linked manually. Is there a simple way to populate it automatically. I have tried Form Rules, and Quickbase Actions with no luck.

------------------------------
Denis Rochat
Rookie
------------------------------

markshnier__you · Answer

np&nbsp; :)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.&nbsp; The formula is even simpler than Excel,&nbsp; the formula is just ....1------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

denisrochat · Answer

Yes - the overthinking is a problem I got. Thanks a million!------------------------------Denis Rochat------------------------------

Forum Discussion

Automatically Enter Reference ID in Child Table

2 Replies