I have a value list in my database with various choices and one of them being flower essence. I would like to know how I can insert two fields that would allow me to type in the type of essence ordered and the date it was ordered when I choose flower essence from my value list.

Any help is greatly appreciated.

Welcome to the forum.

Are you asking how you would add 2 more fields to your layout or is there another table you wish to get the data from?

If the former go to layout mode.

Click on Insert menu item.

Click on Field Control

Choose your fields and enter them.

You can then set up an additional value list of essence types and set your date field as a calendar. (I think you can do this in FM 7. I've never used it.)

Of course the fields must exist in the table. If not go to File>Define>Database and add the fields.

If the later, you must have a relationship between the 2 tables.

HTH, if not please give a more detailed explanation.

Hi,

All I have is one table. All I need is if I select flower essence from the value list the date ordered and the type of essence fields should be enabled to enter the data, if not the two fields need to be disabled so that no data can be entered.

Thank you for all the help.

This gets a little tricky so here goes.

Create a script called Field Validation:

Enter this script:

Now,

Click on field Control>behavior and uncheck "Allow field to be entered in browse mode.

In the "Type" field right click and create a button on the field itself. Check perform script and Field Validation as your choice.

Now when you click on the field the script will check to see if there is data in the type field. If none it will give a warning message. If there is data it will allow data input.

HTH

Btw, of course you do the same for the date field. ;)

Edited October 25, 200718 yr by Guest