I am having a problem with a database (copy attached with user and login "admin"). There are several portals on the layout TheSpace_JobSheet which have relationships to other tables. The problem is that when you select from the popup list for Photographer, say, and then decide to change the value, the changes do not stick. This is true of the other portaled fields as well, such as Producer, Retoucher, etc. Anyone have an insight on the strange behavior? Thanks in advance.

TheSpaceInc.fp7.zip

Do NOT use names as a primary key for a relationship. As example, you have many duplicate names in your Photographer list, this is probably what is causing your problem.

I would recommend you create an ID for the Photographer, and then use that as your Key Field, and see if that doesn't clear help.

Lee

So, if for each of the key fields I create an ID field which auto creates as a serial number, in their table and show that in the popup list along with the name in the Job Sheet, what else do I need to change in the relationship to fully take advantage of this fix? I am a little confused as to the use of an ID as key field, though I have read about it being used before. A little rusty at FileMaker. Thanks!