Jump to content
Sign in to follow this  
JimDiGrip

Finding based on Fields that do Not Allow Entry!!!

Recommended Posts

Hi,

Without boring you with the details tongue.gif 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 ]

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Old Advance Man

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.