When I asked about this a week ago, a couple of people said it wasn't possible and asked if it were to let them know.
I reported a technique that I have been testing, but it was buried in another message, so for the record:
If you want a column based on data in itself or even on a table that has a one-to-one relationship, then just do a query. Then when you want to get rid of the column just close the query (pretty obvious - but worth mentioning)
If you want to get data from another table and use a summary from the second table, this technique does not work as you lose the spatial objects in a group by query.
However, if you make a selection of the table to a name and then do an update table joining the selection to the base table, you can add a temporary table that has the spatial data from the first, and the summary column based on the second.
Again, just close the query table when you want to get rid of the table.
I've been using this, and its been working OK. The join is still dynamic, so changes in the joined table still are dynamically updated in the query.
R
--
Robert Crossley
Agtrix P/L 9 Short St New Brighton 2483 Far Southern Queensland AUSTRALIA
153.549004 E 28.517344 S
P: 02 6680 1309 F: New Connection M: 0419 718 642 E: [EMAIL PROTECTED] W: www.agtrix.com W: www.wotzhere.com
--------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9041
