Hi A customer created a PO with items which she then deleted (not really an ideal way of doing things I know) but then there are some details left in the PO tables which distort reports. Has anyone came across this and is there a fix? Thanks Gareth
You can create a foreign key on tables to avoid this problem..
cod
Can you explain this to me please?
Gaz wrote: > Can you explain this to me please?
ALTER TABLE PurchaseOrderEntry ADD CONSTRAINT fk_itemID FOREIGN KEY (ItemID) REFERENCES Item(ID)
The foreign key allow to insert in PurchaseOrderEntry.ItemID field only values that exist in Item.ID ..
cod
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.