Ok i'm stuck on another one.

I have four related tables retailers, products, price and category
I need to have a form to add any new retailers.
By default, any new retailer doesn't have any products.
What i need is a way of assigning all products to the new retailer
automatically.

Hope someone can point me in the right direction. I know it needs an insert
to multiple tables but im not clear on how to acheive all this.
Thank You

Andy

Here are my tables to make it a little clearer. The tables have
relationships

Retailers: UserId related to Prices UserId
Userid
Retailer_name
Retailer_Logo
Username
Password
Show_Prices

Products: CategoryID related to Category CategoryID
Productid
Categoryid
Product_title
Product_description
Product_image
Product_price

Category: CategoryID related to Products CategoryID
Categoryid
Category
Category_image
Category_text

Prices: ProductId related to Products ProductID
ID
UserId
ProductId
Price