How to create a new record from a parent item and no longer display that parent as an option to prevent duplicates.
I?m fairly new to QB and have been searching for days so hopefully someone can help.
I have the following tables:
-Customers-
Customer Name
Address
City
State
Zip
-Categories-
Category Name
Category Description
-MyFavorites-
Customer Name (from customers table)
Category Name (from categories table)
-Magazines-
Title
Description
Category (from categories table)
SubMonths
Price
-Orders-
Customer Name (from customers table)
Title (from magazines table)
SubMonths (defaults based on Magazines table BUT can be modified during order)
Basically, a customer can first choose their favorite categories which is recorded into the MyFavorites table. They then go to view each of their favorite categories and see a list of available magazines under each category. My problem is I?m not sure how to remove the magazine title from the list of available magazine once a customer has ordered it. I would also prefer that list of magazines to have a ?ORDER? button next to each one that would allow them to modify the number of months they would like that subscription before saving as an order. Help is appreciated!
I have the following tables:
-Customers-
Customer Name
Address
City
State
Zip
-Categories-
Category Name
Category Description
-MyFavorites-
Customer Name (from customers table)
Category Name (from categories table)
-Magazines-
Title
Description
Category (from categories table)
SubMonths
Price
-Orders-
Customer Name (from customers table)
Title (from magazines table)
SubMonths (defaults based on Magazines table BUT can be modified during order)
Basically, a customer can first choose their favorite categories which is recorded into the MyFavorites table. They then go to view each of their favorite categories and see a list of available magazines under each category. My problem is I?m not sure how to remove the magazine title from the list of available magazine once a customer has ordered it. I would also prefer that list of magazines to have a ?ORDER? button next to each one that would allow them to modify the number of months they would like that subscription before saving as an order. Help is appreciated!
