I need some opinions about form design. What i want to do is have a single form that replaces about 30 of them. what the form does is show data from a table in a db based on user input. Basically it is a search form.
you have table a
forma searches table a and returns data. you might have 2 txt boxes and a sheridan data combo.
this form, formb, has 5 txt boxes, a combobox, and a data combo
each form has to generate different sql depending on the input. Basically i want to have a form in a dll with a class wrapper or similar and have that one form show what i need it to. I have though about using meta data. I would rather have the programmers see stuff visually though. It is hard for someone to do a form nonvisually when they didn't write the code behind it. I'll give more points to a intuitive solution. I'm sure someone out there has done this before.