var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help with form controls and multiple tables
Hello, I use LibreOffice Base and have a database about films with the following tables and relations:
FilmID (PK, integer, auto value)
StudioID (PK, integer, auto value)
CategoryID (PK, integer, auto value)
CompanyID (PK, integer, auto value)
These are the relations:
tblCompanies.CompanyID [1--n] tblStudio.BelongsToCompany
tblStudios.StudioID [1--n] tblFilms.Studio
tblCategories.CategoryID [1--n] tblFilms.Category
I want to make a form in which all information about a film is shown, with the following condition:
The Studio and Category fields are shown in two list boxes, respectively.
Plus, both list boxes must contain all their respective options so I can choose when registering a new film.
There are some images attaches so you can have an idea of what I want.
If you need more additional information, please ask.
Thanks in advance!