| | |
|
|
|
query assembly components |
|---|
| message from =?Utf-8?B?TWlrZTI3?= on 18 May 2004 |
I have a parts database which relates bottom level parts to master assemblies as well as to every subassembly up the pyramid including the master assembly at the top. This allows me to find correct part numbers by searching, for example, the name of an assembly and the common name of a part. All this linking is very labor intensive because each bottom level part has to be linked to so many assemblies. I want to be able to link the bottom level part only to the first subassembly that it belongs to, then link that sub assembly to the next subassembly up the pyramid until the last sub assembly is linked to the top master assembly. The relationships in the database are set up to link this way, but I can't picture how to set up a query if there will be no direct link from the bottom level part to the top assembly. Can Access do this & if so, what is the correct method?
Thanks
|
|
Archived message: query assembly components (Microsoft Access Error Message)
