The Tables are different categories of the finances e.g.

Business Rates,
Businesses, (which the tables use a lookup wizard to get the info from)
Ingredients,
Legal and Insurance, etc.

They contain the name of the company that has invoiced the business, the date of invoice, invoice number, the amount, ID (obviously) and whether or not it was paid.

So what i want to do is create a form which my client can search either date, paid (or not) or business to print a report off for the taxman. Does that manke any sense?

---

Reply from Richard Rost:

So you have three different tables with essentially the same information in them? Three different categories of records that really should be in one table? I'm just trying to understand the structure of your database.

To use an analogy that I can understand, you're selling cars and you have separate TABLES to track Ford, Chevy, and Hyundai cars and you want to search for the owners of these cars, but the names could be in any of the 3 tables. Is that correct?