T
TheScullster
Ok so I have a table which contains contract numbers and associated data
records.
How do I create a table and populate it to store link information between
selected records in the above 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
So what I want to do is record any commonality between 2 or more records in
the above table.
For instance it may be that 2 or more contracts occur on the same site.
So I need a mechanism to store the contract "links" and also a memo field to
provide information on the way in which the contracts are connected.
Any advice/starter info appreciated
Phil
records.
How do I create a table and populate it to store link information between
selected records in the above 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
So what I want to do is record any commonality between 2 or more records in
the above table.
For instance it may be that 2 or more contracts occur on the same site.
So I need a mechanism to store the contract "links" and also a memo field to
provide information on the way in which the contracts are connected.
Any advice/starter info appreciated
Phil