Printable View
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???
You will find the check box too crude for sales data. If you want to be able to produce useful business information, you need to record sales in a table of sales. Even if you don't ever need to use this, its also the easiest way to update your stock records.
Make a table of sales and a table of phones. In the table of phones, have a link field that is the foreign key of table of sales.
This field defaults to Null.
For your user, you have a sales form with a subform of phones. It starts as an empty subform but they populate it with the phones being sold.
After the sale is logged in table of sales, each phone will have its foreign key for table of sales populated. Run a SQL query that removes all phones where this foreign key is not null from your stock-list.
I hope I explained this clearly. If not, I can do a small demo in Access 2000.
Thank you, but that bit I already have (but with the checkbox)
In my version, the tbls are phones and sold.
When a phone is sold the checkbox is ticked, (the stock form only shows un ticked phones)
and the sold phones IMEI (Primary key) is added to the tbl sold.
My problem was I couldnt figure out how to do multiple sales that well, but I have a plan which I'll try today, and If it works I'll let you know!
Cheers anyhow :D
Bazz