Read-Only Error Message

[JohnLute]

My supplier database is setup with the NAME of the supplier as primary key. The reason being is that one unique supplier name may have many supplier ID numbers. Therefore, I rearranged it so it's constructed like this:

tblSupplierNames
txtName (pk)
This is the RecordSource for frmSuppliers.

tblSupplierIDs
txtSupplierID (pk)
txtName (establishes relationship with tblSupplierNames)
This is the RecordSource for sfrmSupplierIDs.

tblSupplierContacts
numContactID (autonumber - pk)
txtName (establishes relationship with tblSupplierNames)
This is the RecordSource for sfrmSupplierContacts.

All of the relationships are assigned properly as one-to-many. My forms are made and are properly linked. The problem is with txt.SupplierID. When I try to enter data in the form, I get the message: This property is read-only and can't be set.

I've looked over the property lists at the table and form levels but can't find an answer to this.

Is there something wrong with my design? Where is this property listed?

Thanks for your help!

 

[JohnLute]

Never mind - I found the error. My indexing was goofy. Thanks!