Re: Keeping Relational Table Current-Access 2007

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

I am just playing to get practical use for Access. I am creating a database
of my recorded DVD collection. One of the fields I have created is for the
main actors in the movie. My intention is to be able to query my database to
determine what movies do I have with x actor, or what movies do I have rated
G or PG when the children come to visit, etc. The one field tables I created
are for the actors (so I can check the box for who is in the movie) and
Ratings.

"John W. Vinson/MVP" wrote:

On Sun, 27 Jul 2008 18:52:01 -0700, Stumped-need help
<Stumpedneedhelp@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I am creating my first database in Access 2007 and found when completing
certain fields, my data is redundant. I thought a good solution to avoid
typing was to create a new single field table, linking it to my primary table
in my database with a many to one relationship, and then simply clicking the
appropriate value(s) from the drop down list in that field. This worked
great for the first 20 or so records. Then I needed new values for that
field. I updated the second table with additional records, but can't seem to
get them to show in my primary table when choosing to select that field.

How can I get the additional values to be reflected in that drop down list?

A one-field table would be quite unusual. I think the delay may be
because updating an underlying table will not automatically requery a
combo box based on that table (unless you close and open the form with
the combo box, or requery it by pressing the F9 key, or doing so
programmatically). Just creating a one-field table will not by itself
avoid redundancy though! What are the structures of your tables, what
is this one field, and how are you doing the update?

--

John W. Vinson/MVP

.

Relevant Pages

  • Radio Button
    ... I'm creating a database for a video store, and part of it si to list the actors ... in the each movie, so far everything is working perfectly, but in the form that ... buttons instead of a text field, to input the gender (there is only 2 gender ...
    (microsoft.public.access.forms)
  • Re: Randy Quaid sues Humpback Mountain producers for $10 Million
    ... Specifically where they said that "no actors" were ... listened extensively about this movie. ... Independent Films & BBM won it. ... category are a tiny fraction of all screenplays overall. ...
    (rec.arts.movies.current-films)
  • Re: You cant get there from here
    ... >So in the case below Humphery Bogart would be Order in Movie ... >Now you can build a set of queries that will return up to the top 12 actors ... >>>MovieID ActorID Character ...
    (microsoft.public.access.gettingstarted)
  • Re: Goblet of Fire : Shocker!!
    ... None of the three principle actors are good actors, ... Emma is progressing at ... I don't think he's got much personality, ... >I thought the movie "War of the Worlds" was pretty good... ...
    (alt.fan.harry-potter)
  • Re: The Screaming Skull director
    ... I would like to know more about how the movie ... Alex Nicol, an Actors Studio trainee, appeared mostly in westerns. ... The Screaming Skull was paired variously with Terror ...
    (rec.arts.tv.mst3k.misc)