Re: Sub form not displaying as continuous

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]

.

Relevant Pages

  • Re: Sub form not displaying as continuous
    ... "John Vinson" wrote: ... >>and data entry = False and no difference at all. ... >>Invoice number does this ... > as the Master Link Field and Child Link Field of the Subform control ...
    (microsoft.public.access.formscoding)
  • RE: Automate a default value
    ... First thing this morning I created a combo box on the AV invoice ... Data entry form and that was a good solution. ... Control source Recap Date ... > called RecapDate. ...
    (microsoft.public.access.forms)
  • Re: DOMContentReady and focus() in Opera
    ... of this application is about data entry and management, ... invoice" form, they want to type in an invoice number; ... If the browser's viewport is not large enough to accommodate the vertical size of the page, ... The user could be on a smaller device, or have a smaller-sized window, for multitasking/switching between windows and applications. ...
    (comp.lang.javascript)
  • Re: calculation field FM 8
    ... I need to add a one at the end of username ... as the link field in one of my systems, ... the data entry people than working with obscure codes. ...
    (comp.databases.filemaker)
  • RE: Table Design
    ... this database is created on the fly. ... in and receives an invoice preprinted by head office. ... The data entry operator enters Inv number, ... > form enter the transaction data or have a sub form tied to the transaction ...
    (microsoft.public.access.tablesdbdesign)