AOO Novice Form Question

Creating and using forms

AOO Novice Form Question

Postby TJM100 » Sun Feb 12, 2017 3:11 am

I'm a rookie to Open Office, but it is the tool I am using to build an application for a client. Want to get some best practices before attempting to design the forms.

The project is a music library application, main function is to categorize music for a band to simplify things, a piece of music may have several people associated with it (composer, arranger, lyricist, etc) A person may be a composer for one piece of music and an arranger for a different piece.

So we have tables as follows

SELECTION (fields chart_id, title, genre) - This is the main selection
PEOPLE (fields people_id, last_name, first_name, bio) - This is the list of all "people"
PEOPLE_TYPE (fields type_code, type_name) - Contains the lookup for type of people, A=Arranger, C=Composer, etc
SELECTION_PEOPLE (fields chart_id, people_id, type_code) - this is the relational table that ties the pieces together.

So for example a SELECTION might be (1, Rock This Town, Rockabilly)
It may have several SELECTION_PEOPLE (1, 1, C) (1, 2, A)
Which would correspond to PEOPLE (1, Setzer, Brian, bio data) (2, Wolpe, Dave, bio data)
and to PEOPLE_TYPE (A, Arranger) (C, Composer)

Operationally, a user should be able to scroll through "SELECTION" records. On each selection the user should see a list displayed of associated people (SELECTION_PEOPLE) and should be able to modify or delete them. The user should also be able to add a new associated person (PEOPLE) from the existing list of people, or should be able to create a new people record.

This is one of several scenarios (I've simplified for clarity, the project also involves PARTS, and other components needed to file music in the library, but the best practices for the other pieces can be built in a similar manner to a good solution here) I'm looking for best practice/design using forms/subforms as necessary to build the functionality.
Open Office 4.1.3/Windows 10
TJM100
 
Posts: 1
Joined: Sun Feb 12, 2017 2:51 am

Re: AOO Novice Form Question

Postby UnklDonald418 » Sun Feb 12, 2017 5:25 am

Look in the Examples area of Base Tutorials on this Forum, there are a number of examples you might find helpful, including
https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=40444#p186046
and
https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=42845
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1337
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: AOO Novice Form Question

Postby UnklDonald418 » Sun Feb 12, 2017 5:35 am

Operationally, a user should be able to scroll through "SELECTION" records. On each selection the user should see a list displayed of associated people (SELECTION_PEOPLE) and should be able to modify or delete them.

As you suggested a MainForm/SubForm arrangement would probably work for this.
The user should also be able to add a new associated person (PEOPLE) from the existing list of people, or should be able to create a new people record.

ListBoxes or ComboBoxes might be a way to accomplish this.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1337
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: AOO Novice Form Question

Postby F3K Total » Sun Feb 12, 2017 3:40 pm

Like this?
SELECTIONS.odb
(20.8 KiB) Downloaded 119 times

R
    MMove 1.0.6
  • Extension for easy, exact positioning of shapes, pictures, controls, frames ...
    my current system
  • Windows 10 AOO, LOLinux Mint AOO, LO
F3K Total
Volunteer
 
Posts: 983
Joined: Fri Dec 16, 2011 8:20 pm


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest