I'm making a database which sells phones.

I have on my table, the model, make IMEI(Primary key) and a check box Sold.

when a phone is sold the check is checked, removing it from the Stock table.

I want to be able to sell more than one phone at once. from one form.

I also want it to print an invoice....

Any ideas???