I have created a database (attached) with 3 tables, 01_Artifact, 02_Cult_Period, and 03_Group where the majority of information is entered into the 01_Artifact table. I want to use the 02_Cult_Period table to filter the options available in the 03_Group table to help standardize data entry and have the user select the appropriate entry by clicking on the record marker on the left side of the table. 02_Cult_Period and 03_Groups are linked via the “cult_id” field and both tables are linked to the 01_Artifact table using the “cult_id” and “group_id” fields. When I select the desired Cultural Period and Group in the tables on the data entry form, I can see that it populates the “cult_id” and “group_id” fields on 01_Artifacts (read only fields above the tables on the Data Entry Form), but when I save the entry the “cult_id” and “group_id” for the artifact are not saved. For example, the database includes 2 records, the “cult_id” and “group_id” for the first should be “1” (Prehistoric) and “6” (Arms). The same fields for the second object should be “1” (Prehistoric" and “1” (Kitchen), but the fields only display the entries for the most recent record (“1” and “1”) and zeros appear in the fields on 01_Artifacts.
I am not sure if the problem is being caused by improper main form/subform structure or possibly having the record buttons on the wrong form. Any guidance would be very much appreciated!
Ohh nooo…attached is the nearly final version of the data entry form…As you can see from the tables, I have been struggling to normalize the entries for subforms and retain the “cascading” tables functionality, but I was getting close…or so I thought.
I guess I thought I was closer than I actually am, given that the subform filtering is working (Period, Group, etc.) and the selections appear to populate the field on Artifacts, but I just couldn’t get Artifacts to retain the values when adding new records. I will have to take a closer look at your example and see if I can learn about macros…any suggested resources for teaching a newbie about macros or suggestions for the type of macros I may need to employ?