N
Natalie
I have two tables: mt_tenant_list and mt_inspection_schedule. For both the
me_tenant_list table and the mt_inspection_schedule I have double primary
keys of User ID and Tenant ID. I have over 4000 records in the
mt_tenant_list and 600 records for mt_inspection_schedule.
I have a form associated with mt_tenant_list with a subform associated with
mt_inspection_schedule. The Link Child fields are User ID; Tenant ID, and the
Link Master fields are mt_tenant_list.User ID;mt_tenant_list.Tenant ID.
Question: When I try to change any field in the inspection schedule subform,
I get an error message that says “The object doesn’t contain the automation
object ‘mt_tenant_listâ€
I believe this happens because it doesn’t have a record to store the
information into in the mt_inspection_schedule table and I don’t know how to
make the table include all User IDs and Tenant IDs (all records) from the
mt_tenant_list table when new ones are added or old ones didn’t have any
information to begin with.
Thank you
me_tenant_list table and the mt_inspection_schedule I have double primary
keys of User ID and Tenant ID. I have over 4000 records in the
mt_tenant_list and 600 records for mt_inspection_schedule.
I have a form associated with mt_tenant_list with a subform associated with
mt_inspection_schedule. The Link Child fields are User ID; Tenant ID, and the
Link Master fields are mt_tenant_list.User ID;mt_tenant_list.Tenant ID.
Question: When I try to change any field in the inspection schedule subform,
I get an error message that says “The object doesn’t contain the automation
object ‘mt_tenant_listâ€
I believe this happens because it doesn’t have a record to store the
information into in the mt_inspection_schedule table and I don’t know how to
make the table include all User IDs and Tenant IDs (all records) from the
mt_tenant_list table when new ones are added or old ones didn’t have any
information to begin with.
Thank you