I have an Access 2010 database with two tables and two forms. The tables are Organizations and People. Similarly, the forms are OrganizationsEntryForm and PeopleEntryForm. The People are linked to the Organizations table. Several people can be linked to the same organization. See screenshots attached. On my OrganizationsEntryForm, I created a command button to duplicate a record using the wizard. It works fine.
I did exactly the same thing on the PeopleEntryForm, but instead of copying the record, it creates a new blank record. I don't get any error messages. Is my problem due to the fact that the People table is linked to the Organizations table?
Please respond at a 3rd grade level, I am learning Access as I go and often the answers given are well beyond my ability to understand. Thanks for your patience!