kinrik
05-16-2006, 10:56 PM
hi - i think this will be a quick question.
originally, i wanted to set up an online "metrics entry" form. so that users would not be presented with a blank form repeatedly, having to input similar data over and over, i wanted to grab the data that was repeated and carry it over from one submission to the next, until they were done entering their metrics, and logged off.
i'm fairly new to asp, and have very little other programming experience, so i may be doing things the hard/wrong way.
my idea was to create a quick form as the first page with a drop down that holds the user names. this drop down would be populated from a table in an access database (only one i'm familiar with - don't worry, small number of users and entries overall). once the user identified themselves, they'd bounce to the next page which would have the form.
the page with the form would reference the previous page's name entry and enter it in a read-only form field simply so the user can verify they are entering data on themselves. the rest of the form would be blanks, waiting for them to enter relevant info.
once they were done filling out the form, they's submit it. the intention here waas to have the page dump its contents to the database and then go back to a blank form except the name would still be there, so they knew they were still entering data on themselves.
any help would be greatly appreciated.
** update - to elaborate on the database setup, i am intending to use one table with user names, another table with projects, another with areas, and the master with the compiled data consisting of those entries plus the blanks, like data work started, date work completed, etc. so the master table would be blank at first, the other three would be pre-populated and would not be editable through the form. i'd use proper joins to ensure the tables talked to each other.
originally, i wanted to set up an online "metrics entry" form. so that users would not be presented with a blank form repeatedly, having to input similar data over and over, i wanted to grab the data that was repeated and carry it over from one submission to the next, until they were done entering their metrics, and logged off.
i'm fairly new to asp, and have very little other programming experience, so i may be doing things the hard/wrong way.
my idea was to create a quick form as the first page with a drop down that holds the user names. this drop down would be populated from a table in an access database (only one i'm familiar with - don't worry, small number of users and entries overall). once the user identified themselves, they'd bounce to the next page which would have the form.
the page with the form would reference the previous page's name entry and enter it in a read-only form field simply so the user can verify they are entering data on themselves. the rest of the form would be blanks, waiting for them to enter relevant info.
once they were done filling out the form, they's submit it. the intention here waas to have the page dump its contents to the database and then go back to a blank form except the name would still be there, so they knew they were still entering data on themselves.
any help would be greatly appreciated.
** update - to elaborate on the database setup, i am intending to use one table with user names, another table with projects, another with areas, and the master with the compiled data consisting of those entries plus the blanks, like data work started, date work completed, etc. so the master table would be blank at first, the other three would be pre-populated and would not be editable through the form. i'd use proper joins to ensure the tables talked to each other.