Recent content by allmylists

See, this is what I thought at first but the compound PK's I set up didn't work, so I did more research on the compound PK thing, and got from somewhere that they each had to be individually unique (clearly, wrong information). Your explanation and example make perfect sense, so I'm probably...

Yes No - this might actually be an easy situation - each invoice only ever has one line.

I am trying to make a report from data obtained via ODBC from our batch-based construction accounting software, that I can't make within the software. I'm using MSAccess 2003 in 2000 mode. My objective is a report that lists: inventory item number; inventory description; invoice date; invoice...