<[EMAIL PROTECTED]> wrote: >Mark wrote: > > What I'm most interested in is a way of automatically populating fields > > in the "Individual prints" table with information from the "film rolls" > > table after I enter the film roll # in a form. > >
>OK, I've had a look: > >You could start by trying this: >Under tools you choose "relations" and make a "one to many" link >from the film number in the film table to the film number in the >image table. If you have mistyped some film number you may get an >error. > >Next, when making a form for image data you generate a sub-form >collecting data from the film table. In the wizard, choose to link >the film number in the image data to the film number in the film data. >You should the get a sub form showing the filminformation. Bingo! That's it! Thanks much. :) -- Mark Roberts Photography and writing www.robertstech.com
