I have two tables, one containing points ant the other regions. I am trying to update a field in the points table with the id of the nearest region.can anyone help me with a simple way of performing this update given that I have about one thousand points. Any help would be much appreciated. Tim --------------------------------------------------------- Database Manager Centre for Research on Introduced Marine Pests GPO Box 1538, Hobart Tas 7000, Australia. Phone : (03) 62325222 (switch), (03) 62325213 (direct) Mobile: 0411 560057 Fax : (03) 62325485 E-mail: [EMAIL PROTECTED] --------------------------------------------------------- _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
