I’m sure I am missing something basic here, but this is what I’m trying to do.
I have 1 table with a list of clients and another table with a list of projects.
When I enter a new project, I use the table lookup to select which client that project is for. On the client table, I would like to have a column that pulls in which projects are attached to that clients name. As it is, I can pull in the list and manually select which one is for that client, but it seems like I should be able to filter that list of projects based on the client name. Is there a formula for that?
2nd scenerio, which I assume would utilize a similar filter:
I have a table of purchase orders and a table of vendors. The vendor is selected from a table lookup list. On the vendor list I would like to pull in a bulleted list of just the purchase orders for that vendor.