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
