I am not of the best way to add several Vendors to the same Lineitem of an Inquiry?
Currently my table looks like this
I want to send the Inquiry to several vendors to bid but only on the lines that apply to them.
The end Result should be printed reports for only the lineItems that each vendor is being requested to bid on. And then of course a overview printed report that tells us all vendors requested to bid on each of the lineitems.
I currently have a seperate Vendor table, with the usual things. Would it be better in the product layout to assign all the vendors to the products that they would be on? Or is this location the best link spot?
Any help in understanding this is greatly appreciated.