master/detail

[rdivilbiss]

http://www.rodsdot.com/keneso/showLog.asp
http://www.rodsdot.com/keneso/showCustomers.asp

[keneso]

Thank you very much.

I believe there is a problem with the global.asa
But since talking about iis is OT here, I am going to open a specific thread, please take a look here
http://www.expertsrt.net/main/forum/topic,1180.0/

[keneso]

Did you really believe you could get a rest? ;)

I need please some more help:

The final code, working is still at http://www.rodsdot.com/keneso/default.asp
The download link was also updated to point to an updated copy of the code, and the entire code appears at the bottom of the page.

I noticed some differences between the two, with the one on the page looking the new, and final, while the download is the old one, am I correct?

I realize my db uses slightly different field names than your original, that was for my convenience as a non-Italian speaker.
Note also I removed the auto number from the customers (master) table and use the customerId as the primary key. That is why I have a routine to see if the customer exists before adding any records to either the customer or log tables.

Not a problem, I guess my English is better than your Italian ;)

Is it possible for you to upload the "new" db file, for me to download, please.

Also, I would not store anything in the log table about the customer except the customerId. That was if other details of the customer change, such as their address or position, you will not need to cascade updated to the log table.
So when you view the log, you simply perform a join on the customer and log tables to display the customer information if you wish to see it.

Good idea, only one thing that i need and had on the old setting, the possibility to update a record, from the log page.

Thank you.