1. Home
  2. Point-Of-Sale Software
  3. DB Relationship between PurchaseOrderEntry and a PurchaseOrder

DB Relationship between PurchaseOrderEntry and a PurchaseOrder

I'm trying to write a custom report and am struggling with the above relationship.

How does a purchaseorderentry relate to a purchaseorder? There is obviously a relationship between purchaseorderentry.PurchaseOrderID and purchaseorder.ID, but this relationship alone isn?t enough as purchaseorder.ID aren?t unique in my system. Is it unique with the combination of StoreID?

Oh for some primary/foreign keys!! :-)

TIA Ian

Reply to
Ian
Loading thread data ...

Reply to
convoluted

Hi, Thanks for the quick feedback and information.

As for view> Hi Ian - is this a report for headquarters? Yes, you'll also need to link

Reply to
Ian

Reply to
convoluted

I have some relational databse information and technical documents. Email me and I will send them to you

Reply to
Afshin

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.