Hi, I use a simular system in my job database, but use the job title as the relationship key, my job names are a calculation of client code + job name (lookup list), I then have a portal on the job details layout. If you have to many old records to add a logical job name this might not be useful but it works well for me. T