Can't enter or choose data in form

[DMJ]

I have a form that three fields will not allow entry in. I have pulled fields from different tables and they are all fine except these three. I have checked properties, etc.

[June7]

Unless tables have a one-to-one relationship, cannot enter data into multiple tables by one form. Probably need form/subform arrangement.

[DMJ]

I've attached the form in detail view and my relationship report. Please check as I am using junction boxes I think the forms should be filling.

[June7]

A gang can have many persons. Let's assume each person can have only one gang. That is 1 to many relationshp. Normal data entry would be with form/subform. Main form bound to tbl_Gang and subform bound to tlink_PersonsGang. Master/Child links properties will synchronize the GangID association. Combobox on subform to select persons.

Or main form bound to tbl_Person and subform bound to tlink_PersonsGang. Synchronization on PersonID. Combobox to select Gang.

Another approach is that if every person is a gang member and only ever of one gang, the gang association info could be in tbl_Person.

Not understanding AssociateIncidentID in tlink_PersonsGang. There will be only one incident per person/gang pairing?