Jerry,

Thanks for responding. The reason I don't think it is working is when I try
to cascade changes in the information. I am thinking that if these tables
have the correct relationships, I should be able to have a query (or form)
that would be able to make changes to all two (or four tables) within the
query.

When I attempt to define the relationships I can only define one relationship.
I conclude that I need more tables and so I created four tables:

tblInternalJobs
JobCode (primary key text field)
Grade
GradeCategory

tblPayRanges
(not sure what would be a primary key because there can be more then one of
the same grade. for instance, in the Grade field there can be two of the
same grades (1 for example) and in the field GradeCategory, there can be two
of the same GradeCategoies (Noncontract for example. However, there cannot
be two Grade 1 and GradeCategories Noncontract. The combination of these two
would be unique)
Grade
GradeCategory
Minimum Rate
Maximum Rate

tblGrade
Grade (primary key text field)

tblGradeCategories
GradeCategory (primary key text field)

I may be missing something, so any help is greatly appreciated.
-Scott

Jerry Whittle wrote:
I would much rather use autonumbers as primary keys rather than a combination
of fields as a PK. Actually you can get this to work if your data is
correctly set up. What makes you say that it doesn't work?
Hello,

[quoted text clipped - 28 lines]

Thanks in advance for your help.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1