Thanks...hopefully this simplifies:
TABLES:
Customers
Categories
MyFavorites
Magazines
Orders
Each CUSTOMER has many CATEGORIES
Each CUSTOMER has many SUBSCRIPTIONS
Each CATEGORY has many SUBSCRIPTIONS
I would like the following:
1. Customer subscribes to favorite categories (stored in MyFavorites table)
2. Customer sees list of magazines based on their associated favorites.
3. Customer clicks a button next to available magazines to order.
4. A form would open allowing customer to modify the subscription length before saving (stored in Orders table).
5. Once customer has ordered a specific magazine, they no longer have the option to order the same one again.
I think I have stumbled my way through items 1-4 but am really stuck on item 5.
