[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Base...
- Subject: Re: [libreoffice-users] Base...
- From: Robert Großkopf <email@example.com>
- Date: Tue, 4 Feb 2020 19:50:42 +0100
- To: firstname.lastname@example.org
Only one some hints for the tables and the relations between the tables:
> A. ID
> B. Name <text>
> C. Gender <text>
> D. Number of reactions done <number>
> E. First reaction <date>
> F. Last reaction <date> this is the most recent reaction
> G. Days - Formula =NOW() <cell ref>
> H. Weeks - = <cell ref/7>
> I. Months = <cell ref/4)
> This has worked very well but now I want to be able to gather more
> information using just Columns A, B, C. So, what I can gather from reading
> the Getting started instructions for Base, I need more than one Table. Are
> those listed below suitable.
> Table 1 - Reactors
> Table 2-Performers
> First name
> Last name
Do you need Table 1 and Table 2? Could also be one table all together
wit a field, which shows 'R' for Reactors and 'P' for Performers
> Table 3 - Performance
> Title (this eill be the title of a song, or a dance routine, or a piano
> concerto, etc.
> Date upload
There must be a foreignkey from the Performers to the Performance. The
"ID" form Performers has to appear at "Performance" as "Performers-ID",
if there is only one Performer for a Performance (1:m relation). Could
also be you need a table, which contains the Performers-ID and the
Performance_ID together: More than one Performer for a Performance, also
moere than one Performance for one Performer possible (n:m relation)
> Table 4 - Location
> Concert - open air
> Concert - Hall
How should this table be linked to the other tables?
Calculations and reports won't be a problem. But the most important
problem is to create the right tables. Content in one table shouldn't be
reported too much. But the best start will be one table with all the
content to see which content will be repeated in the table. Then you
could split the repeated content from the table and set a foreignkey to
another table with this content instead.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
|Re: [libreoffice-users] Base...||Michael H <firstname.lastname@example.org>|
|[libreoffice-users] Base...||zed <email@example.com>|
- Prev by Date: [libreoffice-users] Base...
- Next by Date: Re: [libreoffice-users] Base...
- Previous by thread: [libreoffice-users] Base...
- Next by thread: Re: [libreoffice-users] Base...