No script is needed.
If you have a relationship like this:
Projects::ProjectType = StandardCosts::ProjectType (I've had to guess here as to what type of matching field pair you would use.)
Then you can define the cost fields in Projects to auto-enter looked up values from the matching fields in StandardCosts.
Thanks for your help. I had tried this, but had not gone back to change the matching field value, so I thought I was getting the wrong result. Th lookup works perfectly.
I have been trying to learn FM by using it. Unfortunately, that leaves me open to asking very basic questions. Can you recommend some resources that could help me get up to speed a little faster?
Not specifically. There are a number of resources out there, but being a long time user, I haven't a lot of personal experience with any one of them and which one is the best fit for you will depend on your personal skill sit and prior experience with databases and programming.
Ther are videos on Youtube,. There are training Tutorials available. There are a few books on FileMaker you can research on a site like Amazon where you can read any reader reviews....