Getting information from two tables with no apparent relationship

P

Phil

It 's late, I'm tired, and things are getting fuzzy. I have a table of parts
which require numerous identified operations to be performed on them. I have
a list of companies who can perform some of of the operations. I want to
build a query/form whereby I enter a part and it matches the suppliers who
can perform the operations required for that part. How do i approach this?

Thanks.

Phil
(I'd probably figure it out on Monday morning)
 
D

Duane Hookom

Do you have any tables defined yet? If so, please provide the structures with
significant fields. If no tables yet, take a stab at what you think you need.
I would have tables of:

tblParts
tblOperations
tblPartOperations
tblCompanies
tblCompanyOperations
 
Top