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 ?