Filter Records in a set
I have a multiuser database where users enter projects. They go to the project layout and it shows them details of their projects. All good.
As part of a project their is a series of tasks attached to it. You go to the tasks page by clicking a button to the task layout.
However at the tasks page it displays all the tasks for every project. Is there as way to pass a value ie ProjectID to the the task page so it only shows the tasks attached to the project value passed?
The project table is linked to the tasks table by an ID field and it allows the creation or deletion of records via this relationship.
Thanks in advance