Help

Linking tables with columns that have a formula

3477 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Phil_Borreson
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a formula that produces a product ID in one table, I would like link that column to a single text column in another table. Can I create a column that is both a formula and is linked to another table?

2 Replies 2
Roman_Scher
6 - Interface Innovator
6 - Interface Innovator

In this case you should use a lookup field in your second table.

Once you create a linked field in your second table that links to records in your first table, you can then create a lookup field in your second table which looks up the product ID field from the first table.

Octavio_Lopez_S
6 - Interface Innovator
6 - Interface Innovator

Hello,

I don’t think what Phil wants to achieve is what Roman proposes.
May be this should be merged with this other post:

Or visceversa…