This value list will not work because the field cannot be indexed error

[nick_jp]

Hi, 

 

I have a "person" table with firstname and lastname and ct_fullname (unstored, calc).

 

I want to use the full name in a drop down list to set the person id FK field on another form but I get the error.

 

Is there a hack to get around this or do I have to set as a stored field, have script to "recalc" it when people update the person record and run scripts when logging into the system to go through my thousands of users and make sure the stored field value is correct?

 

This seems far too complicated....

 

Thanks

 

Nick

[bruceR]

Set as stored field. Why do you perceive this as a problem?

[Wim Decorte]

What Bruce said; why do you think you need to script an update?  A stored calc or an auto-enter calc will do just fine and updates itself.

[bruceR]

I suppose the premise that there could be a problem is revealed in this statement, which reveals a serious fundamental misunderstanding of FileMaker, of how calc fields work and the difference between calc fields and scripts:

 

"go through my thousands of users and make sure the stored field value is correct?"

 

But we know it doesn't work that way. No need to go through any records; no need to run a script. it is a simple calc; it WILL be correct.

[nick_jp]

thanks. It was a misunderstanding of FMP. Baby steps.