Creating New Tables In Access

Report · Jun 24, 2006

Hi, i was wondering if there was any way of creating a new table in Access by using a webpage. Say im making a site similar to ebuyer and i want a product to have reviews, but theres no reviews for an item hence no table. When a user review this item a table is created with the necessary columns and enters the data from the review into the newly created table.

I realise Access is not very good for this type of site but i do not know SQL enough in order to use MS SQL database yet.

Any help would be appreciated.

Thanks, Adam

Report · Jun 24, 2006

You don't really need to do that. Just create a table called Reviews. You
can add a column called ProductID so that you can identify which product the
review is for.

--
Jules
http://www.charon.co.uk/charoncart
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

Report · Jun 24, 2006

Ok so say i create a database with a main table with the main product details in (ProductID, Title, Price, Description...) and then create a reviews table with a ProductID column and relate them together it would work that way alright ? I could use a memo field in order to store more than 255 Characters.

Thanks for your help Julian. Also i know this has nothing to do with my original question but it is to do with shopping carts. How do i create the numbers in ASP like prices and they deduct and add as needed ? just create a session ID with a value then use then ' price= -1 ' ?

Thanks Very Much,

Adam