Log in

No account? Create an account
Solution to tricky problem requires automation - A Suburbs Boy Living a Country Life — LiveJournal [My Flickr Photos]
December 24th, 2007
12:41 pm


Previous Entry Share Next Entry
Solution to tricky problem requires automation

(6 comments | Leave a comment)

[User Picture]
Date:December 24th, 2007 05:57 pm (UTC)

Another problem

I actually can't do the query with this, because I really need some sort of sequence or unique ID for the update query side of things. "First, last" is not a valid primary key [is not unique, and is null for some business entries without a name field].

However, this example might give you ideas.

The only likely unique id I can find is an OLE Object "EntryID." Apparently, though, you can't include OLE Objects in UNION queries.
Powered by LiveJournal.com