Getting information from two tables with no apparent relationship

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Quering 2 unrelated (apparently) DBs 1
Them delivery services - some good, some not so good 3
query to return 1 value out of many on a single table 2
Junction table 2
Lookup Values From Table 1
Extract data from previous week, previous two weeks, etc. 2
Query shows no results when using 2 tables with multiple relations 3
two tables with matching fields 2

Back
Top