I am creating a database for data collection for a disability screening of both child and adult populations. I have a basic demographic form, and would like to create buttons on that form which open up the correct screening form based on age group (3 forms total). I suspect I could do this through a subform contained within the page(?), but I think that would make the whole thing unreasonably long, ugly, and complex. I believe this will require creating a 1:1 relationship, since each primary key could have one entry at most in each screening form, but many would have none since only 1 of the 3 screening forms will apply to each primary key.
- Create 3 buttons within the main form which:
- First saves the data that has been entered,
- Then opens the specified screening form,
- And auto-populates the Study ID (which will be the foreign key on the screening forms).
Probably this will require writing a macro I suspect, which I haven’t learned yet, but if you could point me in the right direction I would appreciate it.
Thank you kindly.!