Windows 10 
Access 2010 64bit
Using Access 2010 I created a database for tracking services provided to an I/DD population. It includes a table for "Person Served" which records demographic information such as "resident's name", "age group", "functional status", "ID # (which is the pk)". There is also a table for "services provided". The two tables are linked through the field "type of service" in each table. The data entry form is set up in a form/subform format with the "services provided" table being the source for the subform and the "Person Served" table being the source for the main form. The relationship is set so that each person served may have multiple services provided. As a new service is recorded in the subform it creates a new record in the "Person Served" table with the "resident's name" autopopulated. To simplify data entry some of the data is collected with yes/no check boxes (age group for example has 4 checkboxes each designated by the established range of ages). My situation is I need all of the demographic data to autopopulate every time a new "service provided" record is created in the "Person Served" table, currently only the "resident's name" autopopulates. Obviously if I knew what I was doing I would be answering this question instead of asking it so please be as simple as possible. If code writing is involved, I know nothing about it other than smart people can do it.
Reply With Quote
