Kaiden

Found the problem. You were right, the field was not set as a Global field. Thanks again

One quick question. I am able to change the background color per your example. However the changes will only occur in the first two records. Why is that? After the first two records I can not get the background color to show up.

Thank you very much. I knew I was close. I had the formula right but I needed to change the caculation result from date to text. That did the trick. Thanks again Mr. Vodka!

I am almost done with this project. It has been a year and you guys have helped me out a lot. I have one more question. I have a created a group data report that lists the workflow (design, production and design/production), relevant information for each record in that workflow, then the subtotal for the workflow. I need to also show a monthly break down. I have a date field (01/01/2007) that contains this data for each job number when it was created. I need for the report to first group the month, then the workflow along with the job number and the total for each work flow. Example: December Design Job Number 12222 Job number 12223 Total 2 Production Job number 13333 Total 1 January Production Job Number 1444 Job Number 1555 Job Number 1666 Total 3 I keep running into a problem with the date field. I created a subsummary (leading) section above the Workflow subsummary field, but when ever I perform the sort action the month appears next to each of the Job Number section. Example: Design Job Number 12222 12/01/2006 Job number 12223 12/09/2006 Total 2 Production Job number 13333 12/20/2006 Total 1 January Production Job Number 1444 01/03/2007 Job Number 1555 01/04/2007 Job Number 1666 01/05/2007 Total 3 I need for the the date field to first convert the date 01/01/2007 to the month name and then provide the breakdown for each workflow, job number and finally the total for each. Any suggestions? Your help would be greatly appreciated.

Thanks for the help. I was able to create a small report that worked based on the relationship I set up. Thanks again for the suggestion.

I hope you guys can help me with this. I have two databases, one is the master and the other is an archive database. I need to pull information from the archive database into the master database, however I am working in FileMaker 5.5 I know it is a pretty old system but this is what I am working with. What is the easiest way to link these two databases together?

Thanks for the suggestion. I will have to go back and take a look at this. Hopefully it will work in FileMaker 5.5

Thanks for the help. I looked at tables for project line items, but it didn't add the functionality I needed. The repeating fields work. I was just looking for something a little more efficient. Thanks again. Kaiden

Thanks for the help. The lock calculation work great on several of the fields I needed to have locked. However, I also have a set of repeating fields that won't take the calculation. Is there a calculation that will allow me to lock repeating fields? What I've done is set up a form that will allow a person to enter data into two fields. The first field contains a date and the second field is setup for project notes. I used repeating fields to allow the user to be able to add notes on a daily basis. I would also like to be able to lock the previous notes so the person is forced to created a new one rather than go back and alter an old one.

I've recently built a database in FileMaker 6 and I wanted to know if there is way to lock a field after data has been entered into it. I would like to prevent someone from changeing the data in that field.

John, Thank you very much. The script worked prefectly. Cheers, Kaiden

I want the user to be able to clone any record and have the database automatically determine the revision suffix. The revisions will only go from A to D.

First off, you've guys have helped me in the past so I would like to say thanks in advanced. I've run into a little snag. Here is what I need to happen in the database. I've created a script that will make a duplicate of all of the information contained in a form I've built. The script also copies the automated serial number so it doesn't have to be reentered. I would like to be able to add a revision letter to the now duplicated record, example: Serial Number 1901, revision A. If I need to make an additional revision to information in that record I would like to be able to make another duplicate and issue a revision B status. Right now it is a manual process, but I would like for it to be automated. I've gone through several If and Case scripts unsuccessfully. I know I am missing something simple. Your help or suggestions would be greatly appreciated. I am completely tapped at this point. Cheers, Kaiden