lookup help needed for selective items depending on previous field

[arnold_fok]

calculated field : iff([bank]=9,'abc','cat') shows correctly
SELECT list.id, list.name FROM list WHERE list.soort='in' Or IIf([bank]=9,'abc',' cat'); shows other soort as wel (no where clause?)
( list is table with multiple lookups works fine if not want different short list depending on other field)

 

[Joe4]

mmm u like to confuse ur colleagues by switching to forms while they learn to use lookup in database, but tnx

I am not trying to confuse anyone at all, just trying to teach good database design (giving them access to underlying tables in dangerous).
In a well-designed database, your users should NOT have access to the underlying tables. You usually want to limit them to Menus, Forms, and Reports, where you have much greater control of all the data, and can control exactly how data is presented and how users interact with the data.

One of the big issues with trying to do something at the table level where Field B is dependent upon the selection in Field A, what is to keep them from trying to update Field B before Field A?
You cannot control that at the Table level.

Regardless of all that, I told you exactly how you can find out exactly what you want to do. If you take just a few minutes to da a simple Google search, you will find many posts regarding your topic.
There aren't too many questions which haven't already been asked and answered already. It just takes a few minutes to search for them.

 

[arnold_fok]

I am not trying to confuse anyone at all, just trying to teach good database design (giving them access to underlying tables in dangerous).
In a well-designed database, your users should NOT have access to the underlying tables. You usually want to limit them to Menus, Forms, and Reports, where you have much greater control of all the data, and can control exactly how data is presented and how users interact with the data.

One of the big issues with trying to do something at the table level where Field B is dependent upon the selection in Field A, what is to keep them from trying to update Field B before Field A?
You cannot control that at the Table level.

Regardless of all that, I told you exactly how you can find out exactly what you want to do. If you take just a few minutes to da a simple Google search, you will find many posts regarding your topic.
There aren't too many questions which haven't already been asked and answered already. It just takes a few minutes to search for them.

mmm u refer to user access, i refer to restricted lookup , before u refer to search i did lot of those research already and try and retry.
if user try field2 before field1 then its empty and not allowed perhaps ur design is not as solid as u suggest by using form if table support