Hi All,
I'm building an web application to manage instructions based on different parameters (eg. JobCode, State, Customer, Product etc..). I have allocated some 20 filler fields for each of such parameters. The display names of the fields may differ from One Project to another. (multiple implementation).
Some project may not use all the 20 fields but only say 5-6 fields...
Now, one of my colleague is suggesting me to customise the stored procedure to return and accept the fields with column names required by the project, and let the SP do the lookup with actual column names. He also suggests to build controls dynamically.
I thought of providing static controls to all the 20 fields and just populate the labels with the necessary field names and interact with SP using field names "Filler1", "Filler2". This also means we need to make the non-required control invisible...
As more experienced users... Can you enumerate the pros and cons in both...
Thanks