Tailored list of combo box

[radek225]

Is it possible to achieve tailored list of machines to production process in my combo box, every time I click on it? - Please see my sample database

Combo Box - Forms!frmProcessOfOrders.Form!frmProcessOfOrdersDetails!machines

Please see tblProcessAndMachines table to know tailored machines to production process

I created some query - combo box rowsource, but When I moved to another order, "Machine" field of previous order has been blanked. So I abandoned this idea.

 

[jdraw]

It would be easier to answer your question if we had more info (facts) about your "Business" and what you are trying to do.

I see:
Workers
Orders
Machines
Processes

I think you are trying to add some sort of sequencing of Processes, but it isn't clear.

Could you lead us through "a typical business day" or " an Order"?

 

[radek225]

It would be easier to answer your question if we had more info (facts) about your "Business" and what you are trying to do.

I see:
Workers
Orders
Machines
Processes

I think you are trying to add some sort of sequencing of Processes, but it isn't clear.

Could you lead us through "a typical business day" or " an Order"?

It's hard to say about Business process because sample it's only part of it. I will try to describe better, than in my last post

Open first of the two records - column [ProductionProcess] "Preparing material", then [Machine] combo box should has only two rows for choose (Not five as it's now):
-Polar 115
-Polar 74
because in tblProcessAndMachines for "Preparing material" process, we have these two machines

When you will open second from two records - column [ProductionProcess] "Printing", then [Machine] combo box should has only three rows for choose (Not five as it's now):
-CD 74
-SM 72
-GTOZ 52
because in tblProcessAndMachines for "Printing" process, we have these three machines

So the problem is, how to write rowsource of machine combo box, or maybe some vba code, to achieve above listed options in combo box.

 

[jdraw]

I'm looking at your database.

Open first of the two records - column [ProductionProcess] "Preparing material", then [Machine] combo box should has only two rows for choose (Not five as it's now):

Where is this?

combo box should has only two rows for choose (Not five as it's now):
-Polar 115
-Polar 74
because in tblProcessAndMachines for "Preparing material" process, we have these two machines

I don't follow what you are saying.

Why should the combo only have 2 values
-Polar 115
-Polar 74
Why does it have 5? Tell us what are the rules.

 

[radek225]

I'm looking at your database.


Where is this?


I don't follow what you are saying.

Why should the combo only have 2 values
-Polar 115
-Polar 74
Why does it have 5? Tell us what are the rules.

Thank you for your insight
When you open the file, form should open automatically then you will see records which I descibed

If my production process I will choose "Preparing material" - I have two machines where I can do that. These machines They are intended for preparing material. So I shouldn't see other machines for other process, combo box should display only machines for process which is selected in the main form.