What relationship do you have between the invoice and LineItems?
You should have: Invoices::InvoiceID = LineItems::InvoiceID
where InvoiceID is defined as an auto-entered serial number in the invoices table.
I sounds like you are using CustomerID for this relationship.
Thanks Phil. That makes a lot of sense. I'll check that out and let you know how I get on. You guys are great!
Thanks Phil and thanks LaRetta!! Everything works perfectly now. Actually, better than perfect if that's possible, because originally I thought I'd have to switch between my two databases to get the info through. Praise the lord for Lookups! See you both in heaven, you're the best.