On Jan 27, 2010, at 12:00 PM, Robert Kersting <[email protected]> wrote:
> i've got a strange situation with the database I set up for The Comedy > Caravan. > > The booking office has a Rolodex of all the comics-name, address, phone, etc. > > There is another database called Avails that tracks their bookings. > Both are linked by a field comic_name which is a concatenation of > their first and last names: first_name+space+last_name > > When the name is entered into a record in Avails, it plugs in phone, > address, email, etc from the related Rolodex record. > > Except for a comic named "Stressed." No matter what we do, the Avails > record for Stressed will not pull the information from his Rolodex > record. Everything is spelled correctly, the links work for every > other comic and we've tried every which way to enter his Rolodex info. > > We've also deleted the Rolodex file and replaced it. > > Any clue what I should be looking for? There can be stray characters on one of the fields that you use to concatenate the key. This is a common issue when using relationships that rely on keys with user-entered data. Another question I might ask is if this is the only comic in the file that has only one name. That may be breaking the relationship as well. What I would do to make it more reliable is to use an unchanging serial number to relate the records and get away from using data for such duties. The first question a database guy would ask is, "What happens if the person/act legitimately changes their name?" You would lose all that person's related data then. I'd be happy to stop by for a free hour and show you how to tune it up a bit if you want. j. -- Jonathan Fletcher FileMaker 9 & 10 Certified Developer ****NEW Ph no: 502-509-7137**** Fletcher Data Consulting [email protected] Kentuckiana's Only FileMaker Users Group: Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com Blog: http://kyfmp.com Next meeting 2/18/2010 1:00 pm Info & RSVP: http://fmpug.com/scheduleMeetings.php _______________________________________________ MacGroup mailing list [email protected] http://www.math.louisville.edu/mailman/listinfo/macgroup
