G
Guest
I have a DB of parts requiring machining and a DB of machine shops that can
do at least one of the machining operations. I want to select a part, then
the machining operation(s) I need to outsource, and have the query return all
those machine shops that can do the operation(s). The DBs I have created have
no common fields (all the machining operations are Yes/No). How do I build
the query?
Below are the DB's fields.
Parts:
PartNumber
UniqueIdentifier
PartName
Milling
Turning
Boring
Welding
Operation1
Operation2
Plating
Outsourcers:
SupplierUniqueID
SupplierID
SupplierName
Milling
Turning
Boring
Welding
Operation1
Operation2
Plating
Rating
Notes
Thanks.
Phil
do at least one of the machining operations. I want to select a part, then
the machining operation(s) I need to outsource, and have the query return all
those machine shops that can do the operation(s). The DBs I have created have
no common fields (all the machining operations are Yes/No). How do I build
the query?
Below are the DB's fields.
Parts:
PartNumber
UniqueIdentifier
PartName
Milling
Turning
Boring
Welding
Operation1
Operation2
Plating
Outsourcers:
SupplierUniqueID
SupplierID
SupplierName
Milling
Turning
Boring
Welding
Operation1
Operation2
Plating
Rating
Notes
Thanks.
Phil