-Findall and Next Record

[Chirriras]

Hi Guys, I'm back! New project, new problems.

I've set up a database for one of the departments on campus. It is a small database that lists different activities alumnae are interested in assisting with. Using the wonderful advice I got from you all last winter, the page displays beautifully, and all the data is there. Ah! A sight to behold, indeed.

Now here's what I need help on. I have one button set up to "Find all records" (there are only 450 records). It processes and brings up the first record. How do I tell it to go to the next record? I've gone through my CDML Reference, but can't find anything about "Next" or "Next Record". What now?

[Unable]

You may or may not find the demonstration "CDML Linking to the next record" in the Sample Files forum useful to help you figure out a variation for your needs.

Then there is the CDMLRdb which also discusses the necessary tags.

[Garry Claridge]

Are using [FMP-Record] tags. For example:

[FMP-Record]

[FMP-Field: myfield1] [FMP-Field: myfield2]<br>

[/FMP-Record]

Is this what you mean, or do you want the user to "step" through each record?

All the best.

Garry

[Steve T.]

Hi, E.D.! It's not the same thing, but you may want to consider the -findany instead of the -findall action. The -findany will let users browse randomly one record at a time... it's doubtful that someone will get to the 449th record by single-page browsing, anyway. There's a chance of repetition, but not likely before the user stops browsing that way. Or you can just do it the old-fashioned way of showing a list of all the records first, and then letting the user click on something to see more about it.

As for Unable's tip, HERE is why you may want to check out his sample, although I have not gotten around to it yet myself. Apparently, it's not such a simple thing that you want, eh?

Hope this helps some!

--ST

(Edited link to go to 1st page of that thread instead of 2nd. Oops!!)

[Steve T.]

Shheeez! I just checked the link and realized the guy who asked the question accidentally did exactly what you want. He wanted to restrict users to a found set but came up with a solution that apparently does every record in the db... which is exactly what YOU wanted.

Oh, and it looks like Garry came up with an equivalent solution using FMP-link, too.

Funny.

--ST

[Chirriras]

Thanks guys, I'll try this. In fact I think you solved 2 problems for me. On another project I'm doing, we have interviewers who are conducting surveys face to face, and reporting their progress in a database. I want each interviewer to be able to access all their own records, BUT ONLY their own records.

So, with project A the director of the program wants to be able to scroll through all the records, like the "rolodex" icon on the FileMaker screen, but project B needs to restrict the records one can see.

See, I got what I wanted with a bonus!

[Steve T.]

Well, good! I'm glad it's working out but I'm skeptical about the restricting of access to only their own records, though. This was one of the main reasons I did not use FM for the calendar system I am doing right now... (using PHP/MySQL.. eeeggaddd!!)... I could not properly restrict users to their own records... just allow/deny access in general. I believe Unable has another sample file that addresses that problem or something similar, though, if you don't get it quite the way you want.

--ST

[Chirriras]

Thanks again guys. It's working just the way I wanted. And yes, they do want to be able to scan through all the cards (like on a rolodex). As soon as I can set the other button for "previous" record" this one is complete and I'm ready to move on to the next crisis.

(Stay close, don't leave me, okay? I get scared when I'm alone!)