Brand new looking for suggestions

[peciam]

Hi to all,

Very new to access 2003. I'm looking for suggestions on how to approach this assignment.

Here's the setup:

Table in access that contains Labor union contract information, name of local, county, regional office, type, years contract covers, etc.

User now wants to add salary data for every year that each contract record covers, and by job title. So i'm thinking a one to many relationship.

My questions are most likely very basic to most of you, but I'm not having much luck how to approach this assignment. Should I do a sub-form, a seperate form, seperate database, sub-set.

Any help or idea's, examples very much appreciated!

Regards,

Tony

 

[Remou]

Two tables sounds about right, with a main form and subform to display the data.

[tt]Table1:
ContractID - Primary Key
<Other fields>

Table2:
ContractID ) - Primary Key
Year )[/tt]

You may get more information in Microsoft: Access Tables and Relationships Forum: forum700