On Sat, 27 Mar 2010 14:26:48 -0700 (PDT), Lostguy wrote:

Sir,

Here are my tables:

tblDog
DogIDpk, Autonumber
DogName, Text
Breed,text

tblCondition
ConditionIDpk, Autonumber
ConditionDesc, text

tblDogCondition
DogIDfk, number
ConditionIDfk, number

I understand about forms. I was just trying to explain how the form
should look to a user. I am getting wrapped around the "pick date,
then enter dogs, then conditions for each dog" which seems to be a
mainform-subform-subform setup that i don't know how to do.

I appreciate your help!

VR/Lost

But there is no date in any of your tables, and a date is in any case just one
data field - I can't see any point in having a Form with just a date! What is
this the date OF? An examination/visit? Don't you need at least one or two
more tables?
--

John W. Vinson [MVP]