K
Ken
I have the following problem and was hoping someone could help..
I have the following tables:
tblPO --> tblPOdetail
tblIO --> tblIODetail
tblJobReuirement -->tblJobReuirementDetail
(-->shows relationship)
Each 'detail' is linked to tblProducts.
Users can open a job requirement, enter some products required quantities
and some code then creates POs' and IssueOrders(IOs') as required. (based on
quantities of stock which is calculated by a function).
Users can also create PurchaseOrders (POs') on their own.
The problem is I am unsure how to represent cost information.
Each IO has an associated Works Order Ref (Generated by another system and
entered by the user). Each WO Ref is associated to a property ref (again
property ref is on other db)
What I would like to do is provide an option that allows the user to select a
property ref and the db to return the amount spent on that property.
I thought I could either put unit price info in the products table (but prices
change often meaning new products would need to be added each time
the price changed) or put unit info in the POdetail lines, but this would
mean I
couldnt query based on WOref as each PO (and indeed each PO line) could have
many WOrefs
I have the following tables:
tblPO --> tblPOdetail
tblIO --> tblIODetail
tblJobReuirement -->tblJobReuirementDetail
(-->shows relationship)
Each 'detail' is linked to tblProducts.
Users can open a job requirement, enter some products required quantities
and some code then creates POs' and IssueOrders(IOs') as required. (based on
quantities of stock which is calculated by a function).
Users can also create PurchaseOrders (POs') on their own.
The problem is I am unsure how to represent cost information.
Each IO has an associated Works Order Ref (Generated by another system and
entered by the user). Each WO Ref is associated to a property ref (again
property ref is on other db)
What I would like to do is provide an option that allows the user to select a
property ref and the db to return the amount spent on that property.
I thought I could either put unit price info in the products table (but prices
change often meaning new products would need to be added each time
the price changed) or put unit info in the POdetail lines, but this would
mean I
couldnt query based on WOref as each PO (and indeed each PO line) could have
many WOrefs