Desktop

Ask something
Discussion Locked

Access 2000 instruction needed

0 helpful
3 replies

by joe

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by dklippert

Go to the Help file and type "combine tables" in the search box on the Answer Wizard tab.
Choose "Ways to bring together data ..."
This process is close to the very definition of a releational database.

This discussion is closed to new replies.