Can someone take a quick look at the attached database file? Instead of writing a lengthy description I thought it would be best to include the file (a picture = 1000 words). It contains relevant parts only and is only 172kb in size. I am having trouble getting the correct results from a query.
I am currently using 2000 and just used the"convert database to prior version function". Looks like it saved down to 97.
Here is a little background...
For every Job we can have one or more CPO customer purchase orders (usually only one but sometimes there are upgrade adders after getting an order). Then, for every CPO customer purchase order we invoice many CIN customer invoice's (most of our work is long term so we will issue many invoices over time against the customer's purchase order).