Re: [libreoffice-users] Populate database form with table data

On 15/02/12 15:51, Fernand Vanrie wrote:
> On 15/02/2012 15:47, bogus@bogzab.plus.com wrote:
>
> when creating a form, you must "connect" to a datasource and then use 
> a table, query or a sql statement to feed the form with data. When 
> using the form as a data-entry tool then you must have a datasource 
> who accept this
> > I apologise, because this feels like something that should be very 
> > obvious
> > but I have not been able to find the answer for myself.
> >
> > I can create a form in the LO database application and put fields 
> > onto it
> > either through Insert>Field or by opening the Data Sources pane (F4) and
> > dragging and dropping fields from there to the form.
> >
> > The only way I seem to be able to see actual data from the relevant 
> > table
> > in my form is to select a row in the F4 pane and then press a button 
> > (iirc
> > it's called "Data to Fields". This puts the data from that row into the
> > form.
> >
> > What I would like to do though is link the form to the table and provide
> > the form with navigation widgets that allow the user to see teh data 
> > from
> > any record by naviagting through the records. I see there is a toolbar
> > called "Form Navigation" which I can get to appear, but all the icons on
> > it are greyed out.
> >
> > I guess my question is - how do I get this toolbar to work with my form
> > and table the way I expect it to?
> >
> > Thanks
> >
> > Bogus Zaba
Many thanks to all who replied so quickly to this. The resources you 
pointed me at soon provided answers or clues. By using the "Wizard" to 
create a form, I got things working very quickly (I usually avoid 
wizards) and by studying the form that was generated I worked out what I 
needed to do to create the same sort of form in Design view.

Thanks again


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted