Further information to last post: Using Table>Update Column, I have been able to update the new column with the neighbouring SLA's identifier where the SLA.object from SLA_table intersects SLA.object from Duplicate_SLA_table. This successfully returns the first intersecting SLA value, But how could I replicate this functionality to return all intersecting SLA values? Preferably each new intersecting SLA value would be added as a duplicate SLA record (with the new intersecting SLA value as an attribute) appended to the table. I hope this is understandable! Alistair.
*********************************************************************************** This email, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost, if you receive it and you are not the intended recipient(s), or if it is transmitted/received in error. Any unauthorised use, alteration, disclosure, distribution or review of this email is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this email in error, you are asked to immediately notify the sender by telephone or by return email. You should also delete this email and destroy any hard copies produced. ***********************************************************************************
