Have a table with my master information for individuals and would like to automatically export the data to other tables based on the criteria selected. On my master table you can select multiple yes/no fields; when yes is selected I would like the majority of the record to be exported to a second table. (i.e. while entering information, if "Child" is clicked, this information will be populated in the Children table.) I'm not sure how to go about doing this.
Also, when a selection is made, there is more specific information I would like to gather just specifically for the members of that category (i.e. for children I want to enter what grade they're in). Is there some way to create a sub-table that appears when the information is initially being completed? I am able to go in an manually do these things but I'm wondering if there's a way for Access to do it for me.
Note: the information is to be input by members of the public so I want to keep the process as simple as possible by providing one form with all the fields that need to be filled out.
Thanks!
Also, when a selection is made, there is more specific information I would like to gather just specifically for the members of that category (i.e. for children I want to enter what grade they're in). Is there some way to create a sub-table that appears when the information is initially being completed? I am able to go in an manually do these things but I'm wondering if there's a way for Access to do it for me.
Note: the information is to be input by members of the public so I want to keep the process as simple as possible by providing one form with all the fields that need to be filled out.
Thanks!
Comment