D
dhstein
I have a product table which lists all products and a vendor table which
lists all vendors. I have a field in the product table called vendorID
which relates the product to the appropriate vendor. The problem is I'd like
another field in the product table called AlternateVendorID for an
alternative vendor in case the first supplier is out of stock. But when I
try to relate that second field to the vendor table, none of my queries work.
Can I relate both of these fields to the vendor table? What am I doing
wrong? Thanks for any help.
lists all vendors. I have a field in the product table called vendorID
which relates the product to the appropriate vendor. The problem is I'd like
another field in the product table called AlternateVendorID for an
alternative vendor in case the first supplier is out of stock. But when I
try to relate that second field to the vendor table, none of my queries work.
Can I relate both of these fields to the vendor table? What am I doing
wrong? Thanks for any help.