Jump to content
Sign in to follow this  
uemtux

Repeating Field Find

Recommended Posts

I have a repeating field and I need to run a search on the contents of a single repetition across several records.

Example:

Status[1] = 1 Means a project has been opened.

Status[2] = 1 Means it's with an editor

Status[3] = 1 Means it's in mockup

So what I need to do is find all records where Status[3] = 1 but when you run a search on a repeating field it searches all the repetitions. I didn't realize this when I built my database and now it seems as if I may have to start over! Unless someone can help me run a find that does the job...

Share this post


Link to post
Share on other sites

You really should ditch the repeating fields and put your data into proper related records, although with your current example, I dont even know why you chose repeaters to begin with.

Share this post


Link to post
Share on other sites

Yep, it sure may have been a mistake to do it this way, but not if there's an answer to my question. Does anyone know if what I'm asking is possible, or should I just get straight to rebuilding from scratch?

Thanks.

Share this post


Link to post
Share on other sites

Well, assuming that the stages are "accumulating", you could add a calculation field =

Sum ( Status )

and search for "3" in there to find projects that have reached stage 3.

I am not sure that's worth the bother, when a simple redesign could solve the issue. In any case, it's not possible to limit a find to a specific repetition.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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