Master/Child Link between Forms/Subforms

[Stephanie53]

Name: Master_Child errors 2.png  Views: 9  Size: 24.4 KB  ID: 11768" class="thumbnail" style="float:CONFIG" />


Now when I make selection on Master it fills in the wrong info on the info on the Subform section. It wont allow me to select PrimaryID to PrimaryID ..I get that error above.

Please assist??

TIA

Stephanie

[June7]

Error says incompatible data types. Fields must be same data type to link. If PrimaryID is a number type in one table but the other field is a text type, they can't link.

Does this data have 1-to-1 relationship?

[Missinglinq]

As June7 said, Fields must be same data type to link, Text-to-Text, Number-to-Number, etc. The only (sort of) exception is if one of the Fields is an Autonumber. If PrimaryID is defined as an Autonumber, the linking Field must be defined as a Number (not an Autonumber) with the Field Size set to Long Integer.

Linq ;0)>