In my database I have numerous sections; Customer, Supplier, Orders etc and in each of these sections I would like to be able to add tasks for work that is in progress.
I have created a Task table and have a portal in the Customer, Supplier and Orders sections which pulls through data as it is entered in the Tasks table.
The problem that I am having is that ALL tasks are pulled through to EACH portal.
I have tried adding a Topic field on the Tasks table to specify the section it relates to and then filering on each portal using the Topic field but this isn't working.
Does anyone have any suggestions?