Hi,

 

Is anyone knows how to update a composite key relations table where it consists of two 
fields that are both used as primary key.

For instance:  A table called âSalesProductâ (Sales_id, Product_id)

 

I have created two  .cfm template, (data Update template and data entry template) 

 

However, primary keys are embedded as hidden fields to uniquely identify a row to 
update and they are never displayed, thus cannot be edited. The problem is how can I 
update a record with a composite key and hidden. 

 

Cheers,

Fiona

Reply via email to