Foreign key from another table, and a primary key from the one being used.

i am still sort of a novice to access programming,

I have “tblMain” with a primary key “tracking number”
“tracking number” has a one to many with the table “tblPend”
“tblPend” has a primary key “RecordNo” and a status check box “status”

Status...