"John Spencer" wrote

It sounds as if you need at least one additional table.

LinkedContracts
AccountID number type long
AssociatedAccountID number type long
Association text (or memo)

This table would have the two accounts and the reason they are associated.

Thanks John
I'd kind of got this far (in my head) but I'm not sure how to "link" this
table to the existing one.
Is your AccountID field a foreign key linked to ac-id from the existing
table?
Also, is your AssociatedAccountID field a foreign key linked to a different
ac-id from the existing table?

Existing table

Table structure

Ac-id - PK autonumber Account ID Field
Ct-code number Conract Number
Ac-title text Contract description
Ca-code text customer address


Finally what would be the best mechanism to allow for user selection of the
associated records and populating the new table?

Thanks for your help

Phil