Re: [libreoffice-users] Relationships in Base

Hi :)
The best place for documentation is
https://wiki.documentfoundation.org/Documentation/Publications

There are also some good video guides at
http://www.spoken-tutorial.org/list_videos?view=1&foss=LibreOffice-Suite-Base&language=English
although i haven't worked through the Base ones yet.

I'm still hoping that someone else here will be able to give better
guidance about using Base.
Good luck and regards from
Tom :)



On 21 November 2013 14:23, Doug Essinger-Hileman
<greypilgrim@interior-castle.org> wrote:
> On 11/20/2013 4:16 PM, Tom Davies wrote:
>
> > Hi :)
> > Sorry for the delay!  We seem to be a little slow in the last couple of
> > weeks.
>
>
> No problem. Thanks for the reply.
>
>
> > The 2nd table probably needs it's own ID field (yes, it's the right
> > term) even though it's not really going to be used at all.  Is each
> > row in the 2nd table unique to a Contact?  or do some contacts have
> > more than 1 row in the 2nd table?
> >
> > I suspect that the Event Table needs to be a Query rather than a
> > table.  Queries look a lot like tables.  It might need to be a Form
> > instead though and i would build Forms by basing them on Queries.  The
> > Query would pull the information from both tables together then the
> > Form might be what you need to be able to type a name into in order to
> > get the details of that row of the Query.
> >
> > I'm kinda clutching at straws here but i think you need to check on 3
> > things
> > 1.  Give the 2nd table it's own ID
> > 2.  Check the type of relationship linking the Connections table to
> > the 2nd one (ie 1 to 1, 1 to many, or many to 1, (many to many seems
> > unlikely!))
> > 3.  Try using an external back-end to store your data tables rather
> > than the internal one built-in
> >
> > How you do that 3rd thing is still a bit beyond me but there are tools
> > such as Postgresql, MySql/MariaDB, HsqlDB and many others.  I don't
> > know which is best but it probably depends on how large the tables are
> > likely to be.  For any kind of contacts database it's likely to be
> > reasonably small so you could aim for the small, light and fast ones.
>
> And thanks for the info. I'm off to read up on queries. I'm sure I'll have
> some more questions, and will ask them as they arise.
>
>
> Doug
>
> --
> 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