troubleshooting Question

Add multiple records simultaneously

Avatar of thinkwelldesigns
thinkwelldesignsFlag for United States of America asked on
Microsoft Access
17 Comments1 Solution830 ViewsLast Modified:
I'm working on an Access 2007 database for a friend of mine, although databases aren't my primary cup of tea...

He has a small kennels and he needs a dog tracking database, and most of what he needs is easily within my reach. But one issue that he has is regarding tracking vaccines. In one day, he may give 25 dogs a Bortella Vaccine shot and this must be added to each dog's vaccine record.

He'd like a quick way to select the 25 dogs, select the vaccine, the date - then in one form add the Vaccine record all all 25 dogs simultaneously. I'm needing some help on this part. Here is my table structure.

dogs
   dog-id
   birthdate
   sex
   breed
   inactive

vacrecord
   dog-id
   vacdate
   vaccine

So they need to be able to select  XYZ amount of "dog-id" from the "dogs" table, and add a "vacrecord" for each "dog-id".

Any ideas how to set that up?

Thanks,

Dave
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 17 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros