replacing one value for other with if
i have no idea on how to use the filemaker sintax...
i want to do this but i don't know how to code it... could you tell me where i can read a tutorial or give me the actual code for it? what i need is actually very basic i'll leave a pseudo code, thank you very much.
if table1::item1 = "xx" table2::item1 = "xy" else if table1::item1 = "zz" table2::item1 = "xz" else if... end if