I have two tables, they each have a field labeled <PROJKEY>.
In table [BASIC] the <PROJKEY> is an AUTO-NUMBER that is generated with each new project entered. In Table [ADJ] <PROJKEY> is a number field. The fields have a ONE-TO-MANY relationship, ONE from [BASIC] and MANY from [ADJ].

In [ADJ] entries are made for any adjustments to each individual project. And I want to have a form where I can pull up a project through a combobox (which I know how to do) and I want to have a datasheet sub-form showing every previous adjustment PER each project.

What I want the [ADJ] table to show is, for example:

With Proj #3456
Adjustment #1: XX
Adjustment #2: XX
Adjustment #3: YY

With XX being previous adjustments, and YY being a slot for a new entry.

So to sum it up, I want the datasheet subform to autnumber incremental, but only PER each project. And I want previous adjustments to be NON-EDITABLE from this subform.

This way I can open the form, see ALL the previous adjustments to a specific project. I can tell how many adjustments there are by looking at the Adjustment ##, and if I want I can add a new adjustment.

What settings am I missing? Can anyone help?