Creating work order in separate stages

[Leo2019]

Hi All!

This is my first post in the forum, glad to be part of the community.

I'm new to ms access and trying to develop a solution to register manufacturing data such as raw materials, machines, processes, procurement, work orders …etc

The issue is that we manufacture custom products to our clients and in order to complete the data properly in the work order, we have divided the process into 3 stages as follows:

1- Selecting the product
2- Selecting the components of the selected product
3- Registering the specifications of each component

Now, I need to open 3 popup windows from the work order main screen, and each one contains the respective data related to the stages mentioned above, the user should be able to multi-select items from each popup window and proceed to the next popup to complete the process.

How could I make such popup windows to forward the selections from on popup to the following one and by the end of the 3rd one, all selections would be present in the main screen of the work order?

Appreciate your patience and support in advance

Cheers!
Leo

 

[isladogs]

Hi Leo
Welcome to AWF
Both your identical threads were moderated due to the attached file.
For info new users with less than 10 posts need to zip attached files.

I'm sure someone will be along shortly to assist with your questions

EDIT: I see you have also cross posted at https://www.utteraccess.com/forum/index.php?showtopic=2054548&hl= and https://www.accessforums.net/showthread.php?t=77752
Please read this guide to cross posting etiquette https://www.excelguru.ca/content.php?184

 

[theDBguy]

Hi Leo. Welcome to the forum. Have you considered using subforms displayed on tab pages rather than popup forms?

 

[Leo2019]

Hi theDBguy!
Actually, yes I did. However, the selection process and passing data from one subform to another blocked me.

So, I thought about the popup menus could be populated based on tables data then selection boxes would assist in the selection.

I'm all ears to any solution that could conduct the same results.

 

[arnelgp]

you can also show all in one form.

 

[Pat Hartman]

It is the multi-select that confuses me. Selecting multiple components to be assigned to multiple products or multiple specs to be assigned to multiple components doesn't quite make sense.

arne provided a nice example of how I have implemented similar requirements.

 

[arnelgp]

if you can share a sample db with your product, compo specs and the form you have now then we can assist on building the new form for you.

 

[Leo2019]

if you can share a sample db with your product, compo specs and the form you have now then we can assist on building the new form for you.

Dear Arnelgp;

Here you go a copy of the database.

 

[Leo2019]

It is the multi-select that confuses me. Selecting multiple components to be assigned to multiple products or multiple specs to be assigned to multiple components doesn't quite make sense.

arne provided a nice example of how I have implemented similar requirements.

Hi Pat;

It is a multi-select components to one single product, then recording specs for every component.

I've attached a copy of the database.

 

[Pat Hartman]

I would not use the multi-select on the middle table. It just adds complex code where none is necessary. You aren't saving anything with the multi-select since you need to go back and revisit each selection one at a time anyway.

 

[arnelgp]

it's Arabic so nobody dares to touch your db.
one things is you must add autonumber to your tables.
it will help you in linking fields from parent to child records.