Coldfusion + Access 2002 scenario

Hi all,

I posted this a while ago at the coldfusion forums at macromedia, but I love getting second opinions (though I don't have 1 yet at MM).

Well here is my situation. I am working on a site that will allow the owner to manipulate information using forms online so it will affect the whole website. Its a gift basket website and I currently have built a database (not finished) in access 2002. I have a table (content_list) that includes a column for an autonumber itemID and a column for itemname. Well, it is 194 items long (these are the individual items that would go in a basket). The itemID has a relationship in another table called basket_contents where a column is also called itemID. The table basket_contents also includes a column called basketID which matches a particular basket. Anyways, I plan on using the information included in my content_list to display via <li> tags. You with me?

So here is how the plan should work right now.
In the table, content_list, each item has its own id. When I want a particular basket to have a certain set of items, I have to type it out like this

Table: basket_contents

ID----------- basketID------------itemID (remember, there are 194 items)
-----------------------------------------------
1 ------------- 1-------------------- 5
2 ------------- 1-------------------- 10
3 ------------- 1-------------------- 17
4 --------------1 ---------------------22
5---------------1 ---------------------35
6---------------2 ---------------------1
7 ---------------2 ---------------------67
8 ---------------2 ---------------------88
9 ---------------2 ----------------------92

Let me explain what is happening. basketID=1 is named baby basket. Well, I want baby basket to have items number 5, 10, 17, 22, and 35, which could represent beefsticks, cheese rounds, truffles, candy, and wafers. Then basketID=2 wants a different set of items, specifically items 67, 88, and 92.
I took this route so I didn't have to have repetition in the database and if one item needed to be changed, you wouldn't have to do it on 20 different baskets.
What I want to know is, how can I take this method, and using an insert/update coldfusion form, make it so the owner can log on to the maintainance site and figure out what the name of certain items are and which baskets are holding them. I just don't know how to go about doing something like this, especially using numbers as the main means of matching with certain baskets. IMO, as the one updating the content, you would almost have to have a list of the id's and names in front of you just to properly give the appropriate baskets there proper contents. I am not sure if its possible to do something in the form like, value="1,5,14,44,64" or what? Who knows, I may have made this more confusing then it needed to be.
Here is a link of the whole database so far, access database. Maybe this will give you more insight into my structure and relationships.
http://www.btkdesigns.com/something.mdb I THINK YOU HAVE TO SAVE IT TO YOUR HD FIRST, i tried hitting OPEN and it didn't work. It is (640kb) sorry for the file size, I didn't realize it was that big.

Also, on my content_list table, I had to remove a few records because the owner reviewed my list and had to change a few things and accidently had duplicates, so I removed them, but the autonumber didn't refresh, so a few numbers skip. Is that a problem?
Thanks for any help you can provide

Bryan

see http://www.sitepointforums.com/show...threadid=129522

rudy