a database problem !
-
I don't know yet if anyone has this problem! Let's say that I have a database that will store all the information about an order and items and customers… each have a table that is related to the other… The Problem is that the design of the database is not friendly to the user, this mean if I want to put a Data Grid and bind it to the OrderDetails table, then the user will see the ItemId and not the ItemName (Of cores, because the database is well normalized !). So, to work around this problem a made another User-Friendly table and each time the user ask to see an order detail, the code will translate the data from the original Unfriendly table to the friendly table… This worked fine, but what I would do if the user decides to make changes to the order? Again I have to copy the data from the User-Friendly table to the database (unfriendly table!). This is a complex operation and very hard to do, especially if there is a large number of a table I work with in my original database… I have the same problem if I want to use crystal report! Because crystal report will not deal with a large number of related tables, I am forced to make a new table that is a copy of my report design, and each time the user ask to print a report, the data will be transformed to this table, so crystal report can deal with it fine and print the report !! The question is: if there is a problem with my design concept or I should built a new object that inherit from the dataset object and can join tables together and can send the data back to the original database??? And how to do this??