I have two related tables table

[frantik]

Hi

I have two related tables

table 1
projectno, workstage, description

key is composite consisting of projectno and workstage

table 2
project no, workstage, location, category, assignmentno

key is assignmentno

I have just added the workstage field - after finding that projectno was not unique.

The two tables are now related by joining projectno and workstage. (previously this was just projectno)

However - on the input form that previously worked, when trying to add a new record, when I open this form it tells me I can't go to the specified record. The relationship between these two tables is exactly the same as it was only it now includes 2 fields instead of one.

Why won't it let me add any additional records, Can anyone please explain what might be happening?

thanks

 

[dhookom]

Did you add the WorkStage field to the Link Master/Child properties?

Duane
MS Access MVP