How do I direct the data coming in from a connected table to populate a related field on another?

Question

I auto populate a table in the first application (Table 1) with data from a second application using QuickBase Connection.&nbsp; I also have another table (Table 2) in the first application that is related to Table 1.&nbsp; I need one of the fields that is being auto-populated to go into the related table instead of it's own field so the relationship is established.&nbsp; Any suggestions?

mcfneil · Answer

One option is to make the relationship in the new app a formula reference field. Then just reference the value that is coming from the sync table to drive the relationship.

This is assuming both table 1 & 2 are mirrors of the original.

If not, you might have to look at the key fields in the corresponding tables.

scottervin · Answer

I did not know I could convert the Reference field into a formula!&nbsp; Works great - thanks so much.

Forum Discussion

How do I direct the data coming in from a connected table to populate a related field on another?