Jump to content

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


JimDiGrip
 Share

This topic is 7152 days old. Please don't post here. Open a new topic instead.

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 ]

Link to comment
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

Link to comment
Share on other sites

This topic is 7152 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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