So, I am looking for some conformation that I am headed in the right direction.

I need to create and oprganize a deals database that I can use to have my page dynamically display deals when I update them, I am working on the pages to add, delete, and edit listings in the database and have figured out how I will have the data normalized and structured. Now here is my question.

I have different sections or divisions of the company that the some data will be applicable to, some deals will only be for one division and others will apply to many. I was thinking of creating seperate fields in the deals record that will apply to each division.

IE:
deal name | deal ID | Division1 | Division 2 | Division 3 | URL |
------------------------------------------------------------------------------
Free this | 001 | 0 | 1 | 1 | http:|
-------------------------------------------------------------------------------
buy inow | 002 | 1 | 1 | 0 | http:|
-------------------------------------------------------------------------------
coupon | 003 | 0 | 0 | 0 | http:|


So, in regards to this, I would build into the GUI for adding, editing and deleting deals a set of check boxes that could be clicked on for what divisions the deal is applicable to. The script would then check which division fields have a one and list the deal in those divisions.

What I need to have happen is while the front page has specific deals being listed in smaller content areas from all over the site, if you go into a specific division of the site, only the deals for that division will be listed. A good example is the way travel sites have a hot deals link on the front page that applies to all sorts of destinations, but then if you were to go into Hawaii the deals are specific to that location.

I am not sure if there are already examples or tutorials on this, I am getting close, but if anybody has recommendations I would love to hear them. Thanks for any help.

Sean