I am very new to Access and am setting up a database that will house data from biological studies. I have two forms and associated tables set up, the first called "TrapNights" in which information on environmental data during the time of a trap night survey is entered, and a second called "IndividualData" that collects information about specific animals seen during that particular trap night. These two forms/tables are related based on the field "TrapNightID". TrapNightID is the primary key in the TrapNights table, and the foreign key in the IndividualData table.
I want to have the TrapNights form open, have the user enter that data, then click a button that opens up the IndividualData table. The problem I'm having is that I have a textbox field for the TrapNight foreign key in the IndividualData form. I want this to be auto-populated based on the Primary key that was generated for the record that was just entered in the TrapNight form.
At this point, I have the field auto-populating the number, but it is simply displaying the number and is not bound to the field in the table and storing the number in the IndividualData table.
Does anyone know how I can reconcile this and get the data to be stored in the IndividualData table rather than just displaying the number?
Any help would be greatly appreciated, please let me know if any further explanation is necessary. Thank you in advance for any help.