Quering 2 unrelated (apparently) DBs

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
 
J

Jeff Boyce

Phil

It sounds like your tables (DBs are the complete database, tables hold
rows/columns of data) are set up like a spreadsheet, with one column per
operation. This is undesirable in a relational database product like
Access, and will cause you and Access to have to work harder to do simple
things.

I'll recommend that you look into normalization, and modify the structure of
these two tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top