Hi,

Without boring you with the details I have set several fields in my database layout to Not Allow Entry. How do I now find records based on those fields?

Since they do Not Allow Entry, I cannot enter a criteria for Finding! AAAAAARGGH!

I really don't want people to be able to mess (even accidentally) with the set values!

Can anyone offer some suggestions?

Thanks in advance

James

[ March 17, 2002, 08:57 AM: Message edited by: JimDiGrip ]

Hi,

If you create a find layout with entry set to allowed for the fields, but hide that layout in the layouts menu, you can script it to go to that layout only for a find, then return to your locked layout afterwards.

Create stored calculation fields for each field that you want to be able to enter find values in. The calculations should equal the field.

Put these fields on your layout(s) instead of the other fields, and allow data entry in them.

This adds some storage overhead but works fine otherwise since you cannot change the value of a calculation field.

Good luck

Daniel

Can you just make the field read-only? You can still enter values in find-mode, but not in browse.

Old Advance Man

You could allow entry into the field and then validate it. Choose Member of Value List and define the value list to use values from the same field. You could give it a strict validation so that the user can't override.

Use a script to override the entry settings (scripts do this !), but only if Status(CurrentMode) = 1.