I am trying to design a database for a small recruitment agency. It's simple and so far has been working well. There are only two tables; a list of all clients and a list of invoices (each time a client is invoiced, it is stored in this table).

I use an append query to create a new invoice, and each time the invoice is added onto the invoice table. The query asks the user to specificy the client number of the company they wish to invoice. This functions fine.

My problem is that to remember the client number is a hassle. Hence I want to set up a button on the client list which says 'invoice this client' and when that is pressed, it runs the append query. However, I no longer want it to ask what the client number is but instead take it to be the client number on the current record. How would I get it to store the client number on the current record automatically and generate just one invoice for that client?

Any help would be greatly appreciated!
thanxs. lisa.
ps. I have tried experimenting with relationships and have current set up a one to many relationship between the client (one) and invoice table (many)