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?
Linking tables with columns that have a formula
This topic has been closed for replies.
+3In 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.
+2Hello,
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…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.