Hi,
I am creating a system for a friend who has a video shop. Everything was going OK until he asked the following:
1- For the same title he sometimes has DVD, VHS and VCD, he wants to keep separate quantities for each. How can I do that without repeating the Film title three times.
2- He purchases a DVD today for 20$, let's say 10 copies of "Lord of the Rings", then after sometime and even before the quantity is "0", the supplier makes a good offer for the same title and sells it for 10$, he purchases another 10 copies. How to maintain separate prices for the same title with separate quantities, i.e
Lord of the Rings for 20$ still has 4 copies
Lord of the Rings for 10$ still has 10 copies
How can I keep separate prices and above all how can I sell these movies and know which is which.
I need theoritical replies not codes or queries, just the plan how to do that.
Thanks a lot
Paulin
I am creating a system for a friend who has a video shop. Everything was going OK until he asked the following:
1- For the same title he sometimes has DVD, VHS and VCD, he wants to keep separate quantities for each. How can I do that without repeating the Film title three times.
2- He purchases a DVD today for 20$, let's say 10 copies of "Lord of the Rings", then after sometime and even before the quantity is "0", the supplier makes a good offer for the same title and sells it for 10$, he purchases another 10 copies. How to maintain separate prices for the same title with separate quantities, i.e
Lord of the Rings for 20$ still has 4 copies
Lord of the Rings for 10$ still has 10 copies
How can I keep separate prices and above all how can I sell these movies and know which is which.
I need theoritical replies not codes or queries, just the plan how to do that.
Thanks a lot
Paulin