May 06, 2019 03:53 AM
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 ?
May 06, 2019 04:03 AM
May 06, 2019 10:16 PM
sad but true.
Thanks Julian for kicking me awake from dreaming about this ~