Getting information from two tables with no apparent relationship

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)

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

--
Duane Hookom
Microsoft Access MVP


"Phil" wrote:

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)