rangebob

Is the "Alternate background fill" an option that is for FMP 6 or is it a different version? I've searched everywhere that I can think.

Is there a way to just highlight every other row no matter what?

Thanks for the replys. I've looked at the three links provided, 2 are for FMP 7 and the other is to delete records. I only want to omit a duplicate address. I work for an elementary school and we want to be able to send letters home but want to omit brother/sisters from the file and only send one letter to the home. Thanks again.

I'm trying to create a script that will look at all of our records and omit any duplicates. I know that I need to loop through all of the records and look at the address field but I don't know how to set the omit to remove the duplicates. Thanks for your help.

I work at a school and I have an inventory DB. We have several pieces of equipment listed in each room. The second DB is the staff records that from the room number I want to be able to find all equipment and show it on that sheet. If I have a classroom #130 I want to find all of the equipment listed in that room. I attempted to use it even though I assumed it wouldn't work "lookup" by the room # and then show the data but it didn't work (like expected, it shows the first record for every field created. Thanks for any help that can be given.

Thanks for this thread this is what I've been trying to figure out how to do. I'm having problems with it working. I created the script as stanley showed and I keep getting no records match this request. I know that there is matching records that should be found. Thank you for your help.

One of the files are just going to be a portal that has buttons pointing to the other files. The second one will be a data file with student names and other data. The third will be a reports file. When I have a parent check in a child I want to have the student # from the data file copied and pasted to the reports file which will then look up the rest of the students personal data.

I have 3 files for a check in progam for our school. When a parent checks in their student I want to copy thier student number and paste it into a different file so that we can track when and how often students sign in late. I'm using Copy/Paste but most of the time it doesn't paste the student # into the reports file. Thanks for your help in advance.

This is going to be a single file that has multiple layouts. The main fields are student name, teacher name, & contact names. I want to be able to print a tardy slip with reason for being late at the end of the checkin process.

Can you give me a couple of steps on how to do that then?

What I'm trying to have them do is find the teacher name from a drop down list which will then jump to a student layout and then have them find the childs name on that list.

I'm trying to create a latetardy DB for my school. I would like to have 2 different searches which will narrow our school roster down to only a single teachers class list. I would like the parent to find the teachers name first and then have then have them search through that class only to find their student. I'm trying to bypass them looking through 600 records to find their childs name. Thanks for your help.

I'm trying to verify this. I have a intervention field that has about 12 different items in it. If I use check boxes there is no way to count each of the items. Also I would like to say if any one of the items in the value list is checked I want to put a yes in a different field.

Thanks for all the replys. You are all too helpful.

I have 600 records that I've imported and the telephone numbers have no - in them. How do I add the dash into the phone number?