Hi,
I have a table of tasks.
I have a table of action items.
In the third table, we have various information items (records).
Several tasks can be assigned to an information item.
Tasks can have multiple action items.
Each action item has a single Owner.
I want to show only the current action items related to an information item record.
Please recommend the best practice for implementing it.
Best answer by Sachin_191
Sounds like a great project for Airtable. Here's how I'd approach it:
+18Try adding a lookup field into the "Action Items" table to display the linked Task's "Information Item" record, and you can then filter by it
Try adding a lookup field into the "Action Items" table to display the linked Task's "Information Item" record, and you can then filter by it
Thanks. I'll try that.
+4Sounds like a great project for Airtable. Here's how I'd approach it:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
