Sorry for not being clear. The primary key is an auto number, and the linking
field. Lets say Vendor_ID for the PK (autonumber), and VendorNumber for the
number assigned to the vendor.

"BruceM via AccessMonster.com" wrote:

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

.