Public Variable and updating form

[poporacer]

I don't quite follow. I think this is what you are saying. You suggest that in tblOffense, I rename the field from CDCNum to InmateID. I don't understand the part about using it as a ForeignKey.

 

[RuralGuy]

Name your PrimaryKeys something descriptive so you can tell what table the field belongs to. You have named your PrimaryKeys just ID. What table does that field belong to? As far as the ForeignKey in the tblOffense table, I'm suggesting that you add another field with the same name as the PrimaryKey of the tblInmates table (which also needs the PK renamed to something other than ID - OffenseID maybe??) as a long integer numerical field. Put the PK number from the tblInmates in this field and now use the relationship screen to define the relationship. You will see that Access now understands that there is a 1:M relationship between the two tables.