>I was thinking of that, but a client could have 60 trips in a month and I'd rather not have them all seperate invoices. I think it would work better to have one invoice for the month and the trips as details of the invoice.
>
>Thanks,
>
Michelle,

You have to take a step back and think about the business. An invoice is a record of a financial transaction. What is the transaction you are tracking here? It is a trip being taken. When does that transaction occur, when the customer takes the trip. So regardless to whether you like 60 trips a month or not, that is what happens in the business. Trying to alter that in the data will only cause problems.

Record your trips using the data structure that I gave you in a previous message, and when the time comes to print statements thenprint them from the data. You will find out that you don't care how many invoices (trips) there are in producing the statement. But your data will record all the details of everything that goes on so you can produce any information you want about those transactions.