S
Steve
Do you approach your customers in the same one-track view you have looked at
my response in this thread? You saw I made a response and immediately
convinced yourself to take the Arno R, John Marshall, Keith Wilby narrow
minded view. You denied yourself critical, need to know, information!
Take a look at the OP's original post. Quote: "Can someone suggest an
efficient relationships model to make this work?" Now look at my response.
Here it is in its entirety:
I have assumed that your inventory items are consumable and periodically you
purchase items to replenish your inventory.
TblJob
JobID
JobNumber
JobDescription
<<Job Address fields>>
TblItem
ItemID
ItemDesc
QuantityOnHand
TblItemToJob
ItemToJobID
JobID
ItemToJobDate
TblJobItem
JobItemID
ItemToJobID
ItemID
Quantity
JobItemAssignedCost
TblItemVendor
ItemVendorID
VendorName
<<Vendor contact fields>>
TblVendorItem
VendorItemID
ItemVendorID
ItemID
ItemCost
TblItemPurchase
ItemPurchaseID
ItemVendorID
PurchaseDate
PurchaseOrderNumber
TblItemPurchaseDetail
ItemPurchaseDetailID
ItemPurchaseID
ItemID
Quantity
UnitCost
If you need help, I can help you for a very reasonable fee. Contact me at my
email address below.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Now look at what I provided the OP. He asked for a "suggest an efficient
relationships model" and I gave him my suggestion. It was only after this
that I offered fee-paid help for a very reasonable fee if he needed further
help. The OP had a set of tables to work with just as he asked and if he
felt he could take it from that point he was free to start working on his
database. However, if he wanted his database quick and painless, I provided
him a resource to go to get that. That was additional help provided to the
OP whereby he could avail himself of that help if he so decided. That's
called value added in business jargon. That's the same as telling an OP to
go out and buy Ken Getz's Developer's Handbook if he wants to do something
covered in that book. You frequently see that recommendation in the
newsgroups.
The path to success lies in looking at the forest and not a single tree.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
my response in this thread? You saw I made a response and immediately
convinced yourself to take the Arno R, John Marshall, Keith Wilby narrow
minded view. You denied yourself critical, need to know, information!
Take a look at the OP's original post. Quote: "Can someone suggest an
efficient relationships model to make this work?" Now look at my response.
Here it is in its entirety:
I have assumed that your inventory items are consumable and periodically you
purchase items to replenish your inventory.
TblJob
JobID
JobNumber
JobDescription
<<Job Address fields>>
TblItem
ItemID
ItemDesc
QuantityOnHand
TblItemToJob
ItemToJobID
JobID
ItemToJobDate
TblJobItem
JobItemID
ItemToJobID
ItemID
Quantity
JobItemAssignedCost
TblItemVendor
ItemVendorID
VendorName
<<Vendor contact fields>>
TblVendorItem
VendorItemID
ItemVendorID
ItemID
ItemCost
TblItemPurchase
ItemPurchaseID
ItemVendorID
PurchaseDate
PurchaseOrderNumber
TblItemPurchaseDetail
ItemPurchaseDetailID
ItemPurchaseID
ItemID
Quantity
UnitCost
If you need help, I can help you for a very reasonable fee. Contact me at my
email address below.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
Now look at what I provided the OP. He asked for a "suggest an efficient
relationships model" and I gave him my suggestion. It was only after this
that I offered fee-paid help for a very reasonable fee if he needed further
help. The OP had a set of tables to work with just as he asked and if he
felt he could take it from that point he was free to start working on his
database. However, if he wanted his database quick and painless, I provided
him a resource to go to get that. That was additional help provided to the
OP whereby he could avail himself of that help if he so decided. That's
called value added in business jargon. That's the same as telling an OP to
go out and buy Ken Getz's Developer's Handbook if he wants to do something
covered in that book. You frequently see that recommendation in the
newsgroups.
The path to success lies in looking at the forest and not a single tree.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)