Results 1 to 1 of 1
  1. #1
    Join Date
    Mar 2012
    Posts
    1

    Question 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:

    tblFilms
    --------
    FilmID (PK, integer, auto value)
    FilmName (text)
    Studio (integer)
    Category (integer)
    FilmDescription (memo)
    FilmCoverImage (image)


    tblStudio
    ---------
    StudioID (PK, integer, auto value)
    StudioName (text)
    BelongsToCompany (integer)


    tblCategories
    -------------
    CategoryID (PK, integer, auto value)
    CategoryName (text)


    tblCompanies
    ----------
    CompanyID (PK, integer, auto value)
    CompanyName (text)


    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!
    Attached Thumbnails Attached Thumbnails Relations.jpg   form01.jpg   form02.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •