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?
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.
I don’t think what Phil wants to achieve is what Roman proposes.
May be this should be merged with this other post: