hi guys,

i was wondering if anyone could help me.

on my database i am trying to set up system so i can print an invoice for a sale made previously. The reason for this is if a sale is made and i don't print an invoice then, later on i can print it (each sale has a unique sale number). I would like to have it set up so that from one value list you select the client, then from another list (perhaps on another layout) you select the sale relating to that client. At the moment all the sales come up for any client so it is impossible to find the correct one.

I'm hoping there is a way to do this so it will show only the sale numbers relating to that client.

Thanks in advance,

Lucas :P

do you have a relationship from Client to Invoices by ClientID? If so, then you can show a portal of invoices on your client layout. Each portal row would have a button that would take you to the invoice layout using a go to related record from Client to Invoice. From the Invoice, you could easily have a Print button. I usually store a date_printed and a date_reprinted for each invoice.

I don't see the need for value lists.

thanks for your reply.

i see what you mean about a portal but its not exactly what im looking for...

thanks anyway!

Its called a conditional value list. Have a search -- you'll get a lot of results come up.