Hi All,
I'm think I'm trying to achieve something reasonably simple, but possibly having a bit of a slow day as I am stumped - any help greatly appreciated...

When creating an appointment and adding a user via the drop down box this creates a record that uses the user id (initials). At the same time, I would like to create another field in the same record that uses the full user name instead of just the initials.

Reason being, I would like to print out daily rotas & worksheets from the appointment record.

If it makes more sense, it would be perfectly acceptable to run a script that calculates the names on the fly, but I presume it would be better (and only a tiny file size increase) to store the full name in the record?

BTW - we are running Seedcode complete v1.32 on FMP9 / mac

Thoughts?

Thanks in advance...
Matt

You could certainly create a field for the staff name in the event record, but it might be simpler to create a relationship from Events to Staff based on the initials already there and the show the related full name on your reports instead.