Hi Vineet I think I am understanding more, but still not enough to properly help you :(
The business logic of your system is entirely in your own hands. The group cannot really help with that. If you have a tricky form which will generate a multitude of outcomes, you should try making a flowchart for the logic. If the data can be entered in multiple stages, you might have to design your form as more of a wizard. You can make a form with whatever fields you want, validate the data however you want, accept the form and then decide what queries need to be run, and then run them. It doesn't matter how many tables there are. If this can be done in one step great, otherwise you'll have to think about the wizard. You should investigate what happens if the process should cancel/fail part way through, will you have to reverse some entries? If so, you should prob make your queries inside a transaction and then roll-back (if your DB can support this). How long will the queries take to run? If they take a long time, you may prefer to create some kind of queue. Hopefully this can be avoided. Regards, D
