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

Sir,

Yes, I missed that one.

tblVisit
VisitIDpk, autonumber
VisitDate, date/time
DogIDfk, number

Then I linked all the IDpks to their respective IDfks.

Can you see anything else missing?

VR/Lost

So there's one and only one dog on any visitdate? Surely not.

What are the Recordsources of your form, subform, and sub-subform? What are
their master/child link fields?

--

John W. Vinson [MVP]