It's probably too late for this, but I'd have a table just for the
movies themselves, and another table (one-to-many) where you match up
the movies with the various formats (a row for movie 1 in VHS, another
row for movie 1 in DVD, etc). In addition to making your work easier,
when the next big format comes around, it's easy to take into account.
Scott
--
-----------------------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Comparing two records within the query B G
- Re: Comparing two records within the... Bryan Stevenson
- OT (was "Re: Comparing two reco... Damien McKenna
- Re: Comparing two records within the... B G
- Re: Comparing two records within... Nando
- Re: Comparing two records within... Scott Brady
- Re: Comparing two records within... Deanna Schneider
- RE: Comparing two records within the... Cornillon, Matthieu (Consultant)
- RE: Comparing two records within the... B G
- RE: Comparing two records within the... Cornillon, Matthieu (Consultant)
- RE: Comparing two records within the... B G