Great! Thank you - that flash of insight was exactly what I needed!

Have a great weekend!



"John W. Vinson" wrote:

On Thu, 3 Dec 2009 19:28:01 -0800, Colin Penman
wrote:

John, thank you. That is what I suspected. I was wanting to keep the data
entry to a minimum - is there any way to make it easier to enter?
Information like date of visit, rep, store # etc would be the same for many
records. It is time consuming to re-enter the same thing for say 4 product
lines serviced on the same visit (assuming that I have understood your line
of thought - each PL serviced per visit would need one record).

Any more thoughts?

Um?

The date of visit, rep, store etc. would be entered once, and once only, on a
mainform.

The lines data would be entered on a subform, and the only information you
would need would be to pick a product line from a combo box.

Perhaps I'm misunderstanding the nature of the business rules. My idea was
that you'ld have a one to many relationship from Visits to VisitLines.

--

John W. Vinson [MVP]
.