Alistair,
just do a select query, joining the SLA_table with the duplicate (not sure
you had to do the duplicate), viz.
Select SLA_table.SLA "SLA", DupSLATable "Int_SLA" From SLA_table,
DupSLATable
Where SLA_Table.Obj Intersects DupSLATable.Obj Order by 1,2
should give the result you want with one records for each intersecting
record. Add in whatever other columns you want.
r
SLA Int_SLA
1 2
1 3
1 4
2 1
On Mon, 01 Aug 2005 14:25:55 +1000, Alistair Hart
<[EMAIL PROTECTED]> wrote:
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.
***********************************************************************************
--
________________________________________________
Robert Crossley
Agtrix P/L
9 Short St
PO Box 63
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309
F: 02 6680 5214
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
skype: robertcrossley
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17322
