Are you saying that Vendor ID rather than the autonumber field is the linking
field?

Bird Byte wrote:
Yes, the vendor id is different from the primary key. It is an autonum. The
old vendor numbers have to be maintained for historical reasons - all
transactions (up to two years worth) linked to them need to be accessable for
queries.

Is the vendor number different than the primary key? If so, is there a
reason you can't just change the second (presumably visible) vendor number
[quoted text clipped - 14 lines]

I'm grateful for any ideas.

--
Message posted via http://www.accessmonster.com