Automatic field actions

[KNO38415]

Hi, I want a drop down menu to affect the content of another field. For instance, if I choose 'option a' in the field another field will automatically fill with a '$400'. And 'option b' changes it to '$300' and so on. Sorry if this is simple but I'm basically new to FM.

Thanks in advance

Chris

[iamthegrey]

Hello:

Basically you need to do what is called a lookup. In a nutshell you need to have a second database file where "option a" and "$400" are in the same record. Then you set up a relationship between the two databases using "option a" as the linking field. Then you go into your define fields dialog and go into the options for the $400.00 field and click on" lookup" near the bottom of the options window and choose the items which will define the realtionship between the two databases.

After that whenever you choose "option a" in the first field $400 will come up in the second field. Coincidentally, this is a great way to have a customer's phone number and address auto fill in just by choosing their name.