Question Multi Variables Iff Type Function?

[ciapul12]

Hi There
Hopefully there's someone here that can help me to resolve my problem
Currently on my Prodlive1 form I have 2 combo boxes Pack Type and Grower both have multiple columns from which data is the automatically inputted to other fields, Grower combo has a grower type in the 5th column and data from that column goes to field called grower type.
I have a Tables: tblGrower,tblPack_Type and tblCiffRef.
Ok so here's the trick...
On my form I have a Ciff_Ref field which must be auto populated based on the selection in fields: Grower and Pack_Type
There could be few variations:
1)if field pack_type = 2 PACK BAKER X16 TRAY or 4 PACK BAKER X16 TRAY and field growerType = "Merchant" then CiffRef field = Minimum Weight NG.ciff
2)if field pack_type = 2 PACK BAKER X16 TRAY or 4 PACK BAKER X16 TRAY and field growerType = "Grower" then CiffRef field = Minimum Weight.ciff
3)if field pack_type is not 2 PACK BAKER X16 TRAY or 4 PACK BAKER X16 TRAY and field growerType = "Grower" then CiffRef field = Standard.ciff
4)if field pack_type is not 2 PACK BAKER X16 TRAY or 4 PACK BAKER X16 TRAY and field growerType = "Merchant" then CiffRef field = Standard NG.ciff
What's the best way to acheive this? would it be by using a Iff type statement or DLook up?
I would appreciate help on this matter
Thank you
Dan

 

[jdraw]

I think readers and you would benefit if you could tell us about your database in simple, plain English. Your post tells us how you're doing or wanting to do something, but we do know WHAT you are trying to accomplish in "business terms". Once readers understand your database and the goal, I'm sure focused responses will follow.

By the way, there are 2 functions/constructs
IIF -- immediate IF statement.
see this for syntax and example

If Then Else

Good luck.

 

[smig]

Can you explain in simple English what is the problem and what you want to acheive ?