numbers

[Balen]

Hi How are you?
Am happy that i register my name here I think this will be usefull
I want to create a database to manage company tasks

my question is:
I have 1000 RAM when i sale 10 RAM of them the field change to 990 automatically
how can cretae relation to this


the second is:
I want to create field to store all items that i have (RAM, HDD, CPU, .. etc)
and on the table that i enter data i want to create lookup to items
Help Please

thank you very much

[TheShabz]

tblProducts
ProdID(PK)
ProdName
ProdDesc
ProdQty
1
|
|
M
tblLineItem
LineID(PK)
ProdID(FK)
InvoiceID(FK)
InvoiceQty
M
|
|
1
tblInvoice
InvoiceID(PK)
InvoiceDate
...

The above is the relevant table design you should have. This is ignoring customer information which would be joined to your Invoice table but is not shown. When you have a sale, you will create a form that enters the sale. When you enter in the qty, you will run an update query
UPDATE tblProduct SET ProdQTY = tblProduct.ProdQty - tblInvoice.InvoiceQty

That will update your Product table.