I'm working on my first FM DB and am trying to setup a DB that will pre-populate a field based upon what is entered into another field. For example, I want the DB to fill out the name and address fields based upon what is entered into the 'type' field. So, if I enter "Water" in this field I'd like all of the address information automatically entered, but remain editable should I wish to make changes manually. My tiny FM app only has one DB.

I hope that makes sense. Any suggestions would be appreciated.

~Steve

Check out the Auto Enter options for the fields. It sounds like you would want to use the Calculation option with the [color:red]Checkbox [color:blue]"Do not replace existing value of the field (if any)" [color:red]Deselected.

If you wanted something like Aqua to post in FieldB,

Your calculation could be something like:

Case (FieldA = "water"; "Aqua")

Aqua would be posted in the field, but you could change it to anything if you want.

HTH

Lee

p.s., I just noticed that this was in the Value List Topic? I'm not sure why you posted it in this one, is it because you would be selecting the FieldA data from a value list, and then the FieldB data would be based on that? If so, you would also need to Hard code the other possible Value List choices and Answers.

Edited October 16, 200619 yr by Guest
p.s.

Lee,

Thanks for the suggestion. I'm new to FM so I'm not sure where this would be appropriately posted. In looking my scenerio over I think it would be easiest to create a seperate "vendor" database with all the related data; address, city, etc. A key field between the main db and the vendor db would be used to link the two. A lookup field, I suspect, could be used to populate the main db with the vendor info.

~Steve