steve514
Posts: 14
|
| Posted: 12/13/2006, 6:15 AM |
|
I am going to simplify the situation in hopes it will be easier for someone to help me with. I have two tables (A & B). Table A has a primary key and is linked to table B through a one-to-many relationship so that the primary key of table A is the foreign key in table B. Table B is going to store multiple "Contact email addresses" for each order.
So it would look like:
TABLE B:
orderid email
001 abc@yahoo.com
001 djjd@yahoo.com
001 bobms@juno.com
002 gogs@ss.com
I have a form asking the user for the multiple contacts/email addresses for a specific order. The problem is that CCS won't allow me to point multiple fields on a form towards the same column in the database. My question is how do I store/insert the multiple email addresses all with the same orderid (foreign key) into the database through CCS?
I have been trying to get this for weeks now and much help would be appreicated.
I am using DB2 9 w/ CCS
Thanks,
Steve
|
 |
 |
Edd
Posts: 547
|
| Posted: 12/13/2006, 1:22 PM |
|
Steve,
Let me assure you CCS can do this, the first thing you need to check is that the key for table B is ID Plus Email address and that the form to update Table B has recognised that there are 2 columns in the key.
Go into the query builder on the update form to verify that the keys are seen by CCS.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
