changing value lists

[shogunjp]

hey I have two pull down menus and I wanted to change the second menu based on what was selected in the first menu, my fix was this, have the second value list defined from a field, the field it refrenced was a calculation based on the first pull down menu...the calculation part of it worked very well... but the value list didn't update properly sometimes, and was slow to update if it did.... I was wondering if anyone has done something like this, and if so what the fix was......

thanks

[geod]

If you are using FileMaker Pro 5 there is a native function for doing this, just read the help on lookups. If you are using an earlier version, I suggest you browse either fmfiles.com or databasepros.com and check out the Tips & Tricks files avaiable for the workarounds to be used with earlier versions.