I have a strange question. I am creating a database in Access 2000 and I need a way that you can enter the main information ( Customer name, Job Name, total Cost and sell for the P.O.) only once, but enter new information such as individual invoicenumbers, how much the invoice was for, when material had shipped, etc. I have checked the database tutorial “Northwind Traders” that comes with Access and it mentions something about Union Querys, but I either don’t understand it or I have entered the wrong information into it because the stinking thing still doe not work right. You still have to enter all the main information in as well as any new invoice information. Can someone help me out with this type of query or can you show me a way to do what I need to do?
Thanks,
Joe