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
Deleted items not coming off PO
Aug 27, 2007
4 Replies
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
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required