DON'T WANT TO REINVENT THE WHEEL

[rry2k]

Hi,
I've just finished my first ASP app. which is an employment app. that gets filled out on the web and then the info goes into our database. When the applicant comes in I need to extract the info from the database and have a form printed.
This application has 172 fields so I don't want to have to rebuild the form in VB if I don't have to. Any ideas would be greatly appreciated.

Thanks..Russ

 

[stoolpigeon]

Just an editorial comment- 172 fields? That's sick.

I wouldn't load all the info back into a form and print the form. Not unless someone is going to sit there and modify the information through the form. I would just write a report and print all the information out that way.

172 fields. I would be weighing if I wanted the job that badly before I'd even filled out the app.

My two cents.

 

[rry2k]

Good point on the fields. There is a lot of redundency. i.e. education is listed 5 times to allow for 5 different schools. On the report thing, I need a legal document that can be signed so unfortunately I do need to create the form.

Thanks..Russ

 

[stoolpigeon]

>On the report thing, I need a legal document that can be >signed so unfortunately I do need to create the form.

So in what way does the form make it more legal?

A report would eliminate the kind of redundancy you are talking about. It would just print what it pulled from the database- along with any other text you might want to put before and after the data.

That way if they only put in one school, or two then you need not print out the extra 3 spots.

Maybe I am just missing something- and I don't mean to second guess you. But when pulling data from a database- so that you can print it onto paper in a usable format- a report is the way to go. It need not be in a tabular format. It could be in a contract type deal very easily.

Just a thought.

 

[Databaseguy]

Actually, you've got to normalize your database. Education should be a seperate table with an ID field to link it back to the main table..... Tyrone Lumley
augerinn@gte.net

http://server47.hypermart.net/databaseguy