On 19/08/10 05:20, Kevin King wrote: > What about creating a view against the table and using the view in your > join? Actually, what I think he should do is create the three sub-fields as individual fields, then declare a virtual field in your view as "U2-Key", and also make those three fields a composite primary key :-)
Then when he copies across he'll have to mess about a bit, but it's good design on the SQL side as well as the U2 side. Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users