I have a catalog of videos I want to list. The product ID's indicate
whether the video is VHS or DVD. For example 1111-01 = The Teletubbies meet
Jason (VHS) 1111-03 = The Teletubbies meet Jason (DVD). Two records for
each title if available in both media.
In the list I want only one record displayed, the user chooses via radio
button VHS or DVD. But not all title are available in both formats. They
could be either, or, or both.
So the record would be displayed as:
Title - Media (if only one) Choose media (if both) - $price
In the query, how can I create a flag that indicates that an id number has a
partner record which indicates a video is available in both formats?
Thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
