I am try to make a little database, and upgrade from using excel sheets.
for every customer there is a tab(list) of items they have used. The idea is to wait until the list gets big enough or when they have used the item and then invoice them for all some of what is on the list the list.
i used to have a separate list in excel for each customer and then make bold the ones i have made an invoice for, and the ones not in bold were the ones left to invoice later.
I have one table with the items in it and the other tables Customers, Location, Status, suppliers, part number,Invoice.
i have made a form to input the data in to each of the tables, also there is a form to select the Joblocation in a subform with a query showing only those, tick a checkbox to say if the item is ready to invoice.
my problem is when i try to give the items an invoice id it wont work becasue the relationship is one(invoice) - many(items)
i think i need some programming to make it automaticly find all those items for the job i want to invoice for that are ready to be invoice for and then create an invoice number in the invoice table and update the items with that invoice ID
this is the first time i have tried to make a database so maybe my design is wrong too?
thanks
Wayne
Ie
Bob 1
andy 2
James 3
Address1 1
address2 2
...
address5 5
Items List
Description ready to invoice(yes/no) price QTY custid Delid
Golf clubs Yes $50 2 1 5
Shoes No $60 1 1 5
Beer No $5 3 1 5
Car Yes $15000 1 1 5
Printing Yes $2 3 3 2
Cold Drink Yes $0.5 5 2 1
Music CD No $10 2 3 2
Ice No $2 1 2 2
PC health check Yes $20 1 2 2
Dishwasher No $80 1 3 2
for every customer there is a tab(list) of items they have used. The idea is to wait until the list gets big enough or when they have used the item and then invoice them for all some of what is on the list the list.
i used to have a separate list in excel for each customer and then make bold the ones i have made an invoice for, and the ones not in bold were the ones left to invoice later.
I have one table with the items in it and the other tables Customers, Location, Status, suppliers, part number,Invoice.
i have made a form to input the data in to each of the tables, also there is a form to select the Joblocation in a subform with a query showing only those, tick a checkbox to say if the item is ready to invoice.
my problem is when i try to give the items an invoice id it wont work becasue the relationship is one(invoice) - many(items)
i think i need some programming to make it automaticly find all those items for the job i want to invoice for that are ready to be invoice for and then create an invoice number in the invoice table and update the items with that invoice ID
this is the first time i have tried to make a database so maybe my design is wrong too?
thanks
Wayne
Ie
Bob 1
andy 2
James 3
Address1 1
address2 2
...
address5 5
Items List
Description ready to invoice(yes/no) price QTY custid Delid
Golf clubs Yes $50 2 1 5
Shoes No $60 1 1 5
Beer No $5 3 1 5
Car Yes $15000 1 1 5
Printing Yes $2 3 3 2
Cold Drink Yes $0.5 5 2 1
Music CD No $10 2 3 2
Ice No $2 1 2 2
PC health check Yes $20 1 2 2
Dishwasher No $80 1 3 2
