Avatar of SparkyP
SparkyP
 asked on

Creating Muliple Records from single Form

We are Setting up a Standards database for customers. We have a data entry form for our administrator to add new customers. There are 5 different standards that apply to customers, some require all standards, others might have only 2 of the five, or any permutation of the 5.

I want to be able to add the new customer with the form and have check boxes against each of the 5 standards, when the form is saved each of the selected standards creates a new record against that customer.

Can you help please?
Microsoft Access

Avatar of undefined
Last Comment
SparkyP

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
SparkyP

ASKER
Thanks Scott
Scott McDaniel (EE MVE )

I'm curious why you'd grade this a B without asking for more help.
SparkyP

ASKER
Sorry Scott

I'm not 100% au fait with the scoring system. No reflection on the answer just a misunderstanding. Kind Regards Mark
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes