is this possible

[Guest]

There is a database a work that is split so the backend resides on the
server. I have recreated the tables so that I have the full program on my
workstation. I have also linked one of the tables to my database. The
database contains a parts list for everything we build and how many of those
parts we have in stock or on order. I would like to be able to have a query
that shows me just the ones that I select and what other products uses those
parts. I have tried a couple of different thing but I only seem to get the
"shared" parts and not the ones that are not shared for my chosen products.
I don't need to see everything on the backend table that has been chosen but
I would like to see the status of those products and parts in comparison to
the products that I care about. Can anyone help?? Thank you.

 

[manningfan]

Without knowing your table structures, field names and relationships,
all you're going to get is a guess from anyone.

Is it possible? Yes, as long as your database has been built
correctly.

 

[Guest]

tblDevice : ID, Descreiption, Qty
tblDBO_Part (ODBC LINKED) : ID
tblDBO_Requirement (ODBC LINKED) : Workorder_Base_ID, Part_ID

tblDevice[ID] joined to tblDBO_Requirement [Workorder_Base_ID
tblDBO_Requirement [Part_ID] linked to tblDBO_Part [ID]

this shows me the parts needed for the selected devices. I have a very
similar set up for just my products; the only difference being the table
names.

Does this help you to help me?