Selection limited to lookup results

[JIMz_NG]

in my base i have 3 tables, namely “project”, “company”, “contact”.

currently, in the table “project”, there is a field “company” which is linked to the table “company”.
in the table “company”, there is a field “contact” which is linked to the table “contact”.

what i want to achieve is, from the table “project”, i can add contacts to a field which the selection is only limited to the company being selected in the same row.

i have tried using a lookup field but it always show all contacts of that company, which is not necessary true because most of the time i only need a subset of the contacts of that company.

how can this be done ? any hints please ?

[Julian_Kirkness]

Hi @JIMz_NG

Unfortunately, I’m pretty sure this isn’t possible in Airtable at the moment.

Julian

[JIMz_NG]

sad but true.

Thanks Julian for kicking me awake from dreaming about this ~