By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Copy contents of related table to new record??

P: n/a
jim
I have a database which stores information about certain products.

The products (tblProducts) are made up of product contents
(tblProductContents). The product contents may be used in one or more
products. So tblProducts is on the one side of a one to many with
tblProductContents

tblProducts has two fields: ProductCode(primary key), ProductDescription.

tblProductContents has: ProductContentID (primary key), ProductCode
(foreign key), Description, Size, etc.

I want to be able to copy all of the records in tblProductContents
associated with product A to a new product, product B. Ideally selecting
product A from a dropdown and entering a new product code for B.

I'm really not sure where to start. Any pointers much appreciated.

Thanks

jim
Dec 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.