I'm new in FMP12 and I need to do this calculation:
I have 3 fields:
Field 1 (Package Name) Packages are: (Orkid, Mawar, Kemboja, Cempaka) which is choosable
Field 2 (Package Price) Orkid=RM196, Kemboja=RM136, Mawar=RM116, Cempaka=RM96
Field 3 (STMB) is the fix amount: RM196=STMB (RM52) , RM136=STMB (RM32) , RM116=STMB (RM30) , RM96=STMB (RM10)
When I choose the Orkid Package from field 1 which is drop down menu, then outomaticly show RM196 in Field 2 (Package price) and show RM52 in Field 3 (STMB).
Is any body here can help me to do this,