I have 3 tables:
- Purchase Order Header
- Purchase Order Details
- Item Vendor Associations
I want to create a record in Item Vendor Associations for each unique combination of item number and vendor number in the Purchase Order Details table. This is to allow vendor pricing to be saved, then retrieved the next time I order the same item from a vendor.
I have set the match criteria between Purchase Order Details and Item Vendor Associations to be the Item Number and Vendor Number fields. I have checked the box to allow creation via relationship on the Item Vendor Associations table. No records are being created.