Re: One To Many To One Common Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

The normal approach is to use a form and subform. A query on table MOVIE
forms the recordsource for the parent form, while a query on table
MOVIEGENRE forms the recordsource for the subform. The subform's a
continuous form, where the Genre field is bound to a combo box that shows
all the rows in table GENRE.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Paul B" <pabarkley@xxxxxxxxxxxxx> wrote in message
news:0cc7bb49-e7b2-41f8-96d2-9a6be9d6a608@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
This seems to be a perrenial problem with many database designs.
Using a simple example of a movie database (but I have other
examples), one MOVIE belongs in one to many GENREs, and one GENRE has
zero to many MOVIEs. So obviously there is a many to many
relationship. You break that up with an associative entity in the
middle, MOVIEGENRE, that contains the foreign key for MOVIE and the
foreign key for GENRE. So far so good. And if I open the table
MOVIEGENRE and type in MovieID and GenreID in a record, I can add as
many records as I want.

There must be SOME way to get multiple GENREs to show up and
be updatable for each MOVIE. Any suggestions? Thanks.


.

Relevant Pages

  • One To Many To One Common Problem
    ... This seems to be a perrenial problem with many database designs. ... Using a simple example of a movie database (but I have other ... foreign key for GENRE. ... The query that this is based on contains all the MOVIEGENRE records, ...
    (microsoft.public.access.forms)
  • Re: Run a SQL query based on HTML drop down selection?
    ... And here is the relevant PHP query: ... Assume that "$title" is a string of text (not necessarily a movie ... My problem seems to be that I cant use the variable $searchby ... Year, Genre and Director. ...
    (comp.lang.php)
  • Re: Run a SQL query based on HTML drop down selection?
    ... And here is the relevant PHP query: ... Assume that "$title" is a string of text (not necessarily a movie ... My problem seems to be that I cant use the variable $searchby ... Year, Genre and Director. ...
    (comp.lang.php)
  • Run a SQL query based on HTML drop down selection?
    ... And here is the relevant PHP query: ... Genre ... Assume that "$title" is a string of text (not necessarily a movie ... My problem seems to be that I cant use the variable $searchby ...
    (comp.lang.php)
  • Re: Creatinig a database to update in alphabetical order
    ... You can then create a Query which takes all of the records in the ... Some attributes of a movie would be the Title, the studio, ... MovieID Autonumber Primary Key ' links tables together ... Keyword ...
    (microsoft.public.access.gettingstarted)