One filter input for multi-table interface?

[Ron_Daniel]

I have an interface that has been made to show lists of all of the Purchase Orders, Purchase Order Items, and Invoices from clients. (Purchase Orders is a table, Purchase Order Items is a table, and Invoices is a table. Each of these tables uses the client's number as part of the name of the record.)

Right now, the only solution I have to show everything for a client is to enter their client number into three separate filter elements. (Each filter element is connected to a list in the interface - a list of Purchase Orders, a list of Purchase Order Items, and a list of Invoices.) The filters all work with the same search term because of the client's number being used in the name of the records in the three tables.

Is there a way to somehow tie these together so that I can enter just one piece of information in an interface and have it display results from three different tables?

[Matt_Jastremski]

The first thing that comes to mind is to have a Customers table that links to one or more of the other tables and filter by that. Is that an option?

[Ron_Daniel]

Unfortunately, it's not. It's a pretty complex system with different groups of clients buying different services, but the invoicing is distributed a potentially different client or group of clients, and at varying percentages. Which is why the clients, the purchase orders, the purchase order items, and the invoices all have to be uniquely identified in their own tables. (Heck, I'm surprised I was able to SEE it all in one interface. My post is to see if I can make it perfect lol)