Hi all,
Forgive my flattened forehead.I've spent the better part of
half a day trying to do something I thought was going to be relatively
simple.
I have two tables. One a 3000+ point object table and the other a like
amount of text objects. The text objects are all whole numbers and
relate to the nearest point object. What I want to do is update a
column in the point table with the text from the text table for the
corresponding point. Unfortunately, there is not a one to one
relationship between point and text i.e.: the 6th row in the point
table doesn't necessarily equal the 6th row in the text table so I can't
use rowid to join them. I've tried setting a 3 meter buffer for all the
point objects and using the "object from the text table is within the
object from the point table" and using the expression
"val(str$(objectinfo(texttable.obj,3)))" for updating my integer column
in the point table .Didn't work, I afraid!
I don't have anything in common between the two tables that I can use to
join them.
Anybody have any hints?
Thanks in advance,
Dan Donnell
NGA
