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.
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?