View Single Post
  #3  
Old May 28th, 2007, 10:57 AM posted to microsoft.public.access.gettingstarted
Albert D. Kallal
external usenet poster
 
Posts: 2,874
Default ACCESS DVD Database

In addition to what I posted, the question becomes how normalized you want
your data to be.

Further, do you have provisions for the actors in movie? Do you want to be
able to search by actors?

The normal approach here is to import the data, and then decide if you want
to re-form the data to multiple tables. or, if you just want to keep your
simple data as you have.

It is not clear if you have "repeating" data for a single dvd (by repeating,
I mean "many" actors can be attached to one movie). if you just have a plain
Jane flat file without any repeating data, then the import is easy. If you
have "repeating" data for a single dvd, then more efforts in design will be
needed.

As for the link to the image field, I would actually just leave that as a
normal text field. You can then place a image control on the form..and it
will display the image for you.

Take a look at the sample. And, if you want to get fancy, you could have the
data base pull the data from the IMDB (so, you can have a list of actors
etc. for your DVD's, but don't have to type them in).



--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada