I'm working with a legacy database that is not normalized, nor can i change it to normalize it and/or add relationships. I've successfully got my List and Details pages up and running and am now moving on to insert/edit. Here's my challenge:
The insert page needs to accept data that will be written to multiple tables (i.e. consider a customer call where we're creating the customer, the customer address record, etc. on the fly). In addition, the customer can either be a "customer" or a "prospect", each being a separate table.
Any suggestions as the best approach to tackling this issue. My gut feel is that I should write a standard aspx page and hook up the data manually. Not sure how to navigate to this page from the insert / edit button (modified routing).
View Complete Post