On Sat, 27 Mar 2010 13:16:13 -0700 (PDT), Lostguy wrote:

Hello!

For a Veterinarian database, I can't seem to get the form/subform
structure working.

Open the form. Enter the date. Then, in a subform below, enter the ID#
of the dogs that showed up that day. (could be one, could be 50). When
you enter the ID, info for that dog can be seen (name, breed,etc.)


Then for the selected dog (another subform?), enter the conditions the
dog has (could be 1, could be 50). (Cough, limp, etc.)

??

VR/Lost

Let's start with tables, since they are fundamental; forms are just windows,
tools to manage data stored in tables. If your table relationships aren't set
up correctly you'll have no end of trouble with your forms! How ARE your
tables set up?

Just FWIW, in my animal-shelter database veterinary services module, I use
tables for AnimalOwners, Animals, Conditions (a table of all the medical
issues that might be encountered), AnimalConditions (linked to Animals and
Conditions), Visits, and several more auxiiliary and lookup tables - not
trivial!
--

John W. Vinson [MVP]