Take a look at the Northwind sample database that comes with Access. It has
good examples of the structures you need for client - product - invoice
data.
-TedMi

"StevePlym" wrote in message
...
I have a very datab ase which lists my clients, addresses and other
information about them - including their unique reference number.

I now want to create a database of invoices written in the last 2 years
and link this to the client batabase. If possible I'd like to autocomplete
some fields in the Invoice database from the Client database.

Assistance welcome. Thanks in advance.


Steve