Re: Sub form not displaying as continuous



"John Vinson" wrote:

> On Sat, 21 May 2005 19:26:02 -0700, FatherBob
> <FatherBob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Marsh thanks for the suggestion but I have tried it with data entry =True
> >and data entry = False and no difference at all. I wondered if the form
> >had been corrupted - so I built a new one - same thing. I am probably
> >making some fundamental error - but I don't know what it is - nature
> >of the beast. Is it at all possible that it is a data related problem - I
> >looked at the tables and noticed that the Ordersub was not keyed on
> >Invoice number (which is the primary key of the Order master) does this
> >matter? is it worth changing the table and rebuilding the forms? Or am I kidding myself?
>
> The Ordersub table should *contain* an Invoice Number field as a
> foreign key, but that field should not be the Ordersub table's Primary
> Key (if that's what you mean by "keyed on". You'ld use Invoice Number
> as the Master Link Field and Child Link Field of the Subform control
> to maintain the link. Is that what you have?
>
> John W. Vinson[MVP]
>
> John, When I looked the suborder was not indexed (that is what I meant by Keyed) So I set it to indexed dups OK. I guess my question is - is it worth rebuilding now I have changed the key or am I just interfering with myself?
Since the last post I tried changing the sub form to a Data*** - it works
fine! But it looks like S**T If you guys have no divine inspiration then I
will go with the data*** and try and figure out what the quirk is with this
continuous form stuff.

Regards and many thanks Bob.
.