I have a relational structure like this:
Table for Companies with whom we work
Table for each contract year for the Companies (each company can have several 1-yr contracts)
Revenue Share and Payments Tables for each Contract year
Right now I have an autonumber field as the Primary key for the Contract Year Table.
What I'd like to do is create an ID automatically that is more meaningful. Say, "CompanyID-01, CompanyID-02, etc." rather than a) have the autonumber assign it or B) have to manually enter it.
Is there a way to do that?