Hi. I have a table with two linked columns. In one column you select a the Client (from the Client table). In the next column you select the Project you are working on for that client (from the Project table). (In the Project able there is a linked field to the Client table). When I go to select the Project, every project in the project table comes up, instead of only those projects related to the Client in the previous field. Is it possible, when I select a particular client, only their projects show up as choices in the next field? Let me know if you need any further clarification. I’ve tried my best to summarise below.
Table 1 - Current Tasks
Linked field Client Name (select client)
Linked field Project Name (the select from projects only related to the client in the previous field)
Table 2 - Projects
Linked field Client Name
Table 3 - Clients