Re: [libreoffice-users] entering records

Just to inform all users: I got the answer in the cross-post mentioned
earlier which is
http://forum.openoffice.org/en/forum/viewtopic.php?f=61&t=61646


On Sat, May 11, 2013 at 1:58 PM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

> Hi :)
> Errr, you know you can write your reports in Writer rather than in Base?
> It gives a lot more flexibility that way.  You 'just' need to connect your
> Writer document to the database.  Errr, that is where i get stuck though as
> i don't know how to do that yet! :(
>
> With database programs in general it is "best practice" to build Forms and
> Reports from Queries, rather than directly from Tables, because it gives
> more flexibility and makes it easier to fix if/when accidents happen (such
> as the back-end suddenly vanishes making the Forms freak out) or when the
> table needs to grow or change.  A Query can be a simple as "show all the
> data from the Table".  Obviously the Query itself doesn't hold any of the
> data, it's just an abstraction so it forms a buffer between the Table and
> the Forms and Reports.  It can be useful to have it do some "filtering or
> "sorting" so that by the time the Forms or Reports are looking at the data
> it's all neatly sorted already.
>
> With Base a lot of weird things go wrong when using the internal back-end
> to hold the data in the Tables.  It is really designed to be used with an
> external back-end.  This makes it highly scalable.  There are a lot of big,
> powerful back-ends such as MySql/MariaDB, PostgreSQL or smaller, lighter
> faster ones (although the only ones i have heard of are Java-based ones
> such as HsqlDB).  Apparently PostgreSQL has the best support in terms of
> their devs supporting Base although people on this list put a lot of work
> into the connectors or MySql/MariaDB and they are easier to contact.
> Someone recently surprised me by saying that his MySql back-end was
> extremely fast so maybe it is good for small amounts of data too and not
> just large, hefty tables.
>
> There is some documentation about Base but it's slow going.  The most
> complete is on the Faq page
> https://wiki.documentfoundation.org/Faq
> but the handbook is getting really close too now
>
> https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Handbook
> That 2nd link also gives you the Base Guide's first few chapters which is
> a lot heftier as you will notice.
>
> Sorry that none of this directly answers your question!  Hopefully others
> will be around soon that can help more directly
> Apols and regards from
> Tom :)
>
>
>
>   ------------------------------
>  *From:* rounak jain <rounak.mint@gmail.com>
> *To:* users@global.libreoffice.org
> *Sent:* Saturday, 11 May 2013, 4:28
> *Subject:* [libreoffice-users] entering records
>
> Three Tables:
> I am writing the fields in Table.FieldName format below.
>
> 1a. Customer.ID
> 1b. Customer.Name
>
> 2a. Invoice.ID
> 2b. Invoice.Customer Name
> 2c. Invoice.Customer ID
>
> 3a. Invoice Details.ID
> 3b. Invoice Details.Invoice ID
>
> 1a, 2a, 3a are all primary fields.
>
> Relationship one to many between:
> 1. Customer ID.ID ->Invoice.Customer ID
> 2. Invoice.ID -> Invoice Details.Invoice ID
>
> Now, in Filemaker this was the way to use the forms:
> Create a new Invoice (i.e. create a new record using a Form based on
> Invoice Table).
> Enter a value in the field Invoice.Customer Name  (a combo box populates it
> with values from Customer.Name)
> I have been able to reach upto here in Base.
>
> This is the part where I need help:
> In Filemaker, the Invoice.Customer ID field used to be setup as a lookup
> field to auto-retrieve the Customer ID number from the Customer Table when
> an entry was made in Invoice.Customer Name. The obvious purpose of doing
> this is to link the Invoice and Customer table. I do not know how I am
> supposed to get this done in Base. Hope I am clear. Kindly let me know if I
> am not. Thank you for your time.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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

-- 
To unsubscribe e-mail to: users+unsubscribe@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