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?
Page 1 / 1
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.
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…
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.