Hi All, I've searched a few times, because I didn't want to post a repeated thread, but I can't seem to find what I'm looking for. Here is a little background on my database so you can get a better understanding of what I'm having problems with:
I currently have a database (Access 07) of assembly process instructions for several different parts(I work at an electronic manufacturing plant). These assembly process instructions(APIs) each have the following attributes in one table; Part No, Customer, Revision Level, Origin Date, Approval Date and Engineer. Each API is also stored in a separate table with the steps required in the process. (Example: Part No:1234 StepID:1 Operation D, Part No:1234 StepID:2 Operation C, Part No:1234 StepID:3 Operation X).
My problem:
I've created a form with a query and a subform which when you type in the API# in a textbox and click search, it will return the data I mentioned above (Part No., Customer, etc.) My problem now is that I'd like to also insert a table into this form which will display all of the steps required for that API when you click search (I've included an edited screen shot of what I want the form to look like for better understanding)
I realize this is very confusing, but it doesn't seem to me to be that complicated of a task, for someone who knows what they're doing at least.
Any help at all would be greatly appreciated. Thank you very much in advance!
I currently have a database (Access 07) of assembly process instructions for several different parts(I work at an electronic manufacturing plant). These assembly process instructions(APIs) each have the following attributes in one table; Part No, Customer, Revision Level, Origin Date, Approval Date and Engineer. Each API is also stored in a separate table with the steps required in the process. (Example: Part No:1234 StepID:1 Operation D, Part No:1234 StepID:2 Operation C, Part No:1234 StepID:3 Operation X).
My problem:
I've created a form with a query and a subform which when you type in the API# in a textbox and click search, it will return the data I mentioned above (Part No., Customer, etc.) My problem now is that I'd like to also insert a table into this form which will display all of the steps required for that API when you click search (I've included an edited screen shot of what I want the form to look like for better understanding)
I realize this is very confusing, but it doesn't seem to me to be that complicated of a task, for someone who knows what they're doing at least.
Any help at all would be greatly appreciated. Thank you very much in advance!
