Recent content by zwheeling

ok, thanks for the help, I actually already know how to do that with a table, I should have been more clear I appologize, I am looking to have that list in a form where the user can select using a check box to decide if they want to be veiwing Manufactured and/or Purchased parts, the assemblies...

Hi, I have two tables, one that contains an overall list of parts and assemblies, and a second that contains a list of all parts that make up an assembly, what I am trying to do is display one overall list and when you double click an assembly on that list all the parts that make up that...

in my previous reply the parts that belong to the assembly should also be indented.

Thanks for the help, I was able to get the combo boxes working and I can choose the assembly then get the combo box to show the parts, but is there anyway to do it without the combo box. Basically what I want to do is as follows: Start with my list of parts and assemblies: Part 1 Part 2 Part 3...

Yes I can build a query using the wizard, and then add expression criteria. I have read about using sub-forms and macros in access but haven't really put the knowledge to use yet. I only recently started building this database and everyhthing I have learned is off the web or what I have read...

I am new to access and I am building a database to keep track of parts and assemblies, I have one table that holds all my parts and assemblies and I have a second table that holds a separate list of all parts that belong to each assembly. What I want to do is to be able to show an over all list...