What is the reason to do that if the tables are not related? I think you must create the Linked Record field.

They are related, but not linked, i have a table that pulls data in from may tables. Based on the info pulled in i will need to look up a value to display. This seems probably to complex but i thought I would ask. So currently the Lookup Cell type asks for a table to look up, i thought it could ask what Column in the Current Table, then what table and then what to return.

starting to ramble.

THank you

I don’t understand nothing on your explanation :grinning_face_with_sweat: Let me try to reply:

Just link them.

So you already have them Linked? :thinking:

You can use a Formula field to “reference” other fields in the same Table, do calculations, logic operations, etc.

Ah, ok, you want to do in reverse order? A field belongs to a Table, so you first need to specify the Table (previously linked, of course).

If you explain your use case or your base structure, I’m sure we could advice you better.