B
Bruce Groen
I need some help on the best way to do this. I am writing an application in
vb.net and asp.net. It is using a SQL 2000 database. I have a list of
objects in a table that looks something like this:
ID ObjectName PropName PropName2 PropName3
1 Object 1 Property1 Property2 Property3
Then I have a fairly basic user table with a userid for each user. The
users login and request objects. When they request an object, I add a
record to another table with the ID # of the object, the ID # of the user
and the time and date they requested it. Now the administrative people need
to login and assign the object to one of the people that requested it. I
can't figure out how to display the data and take the user input. I have
been using a data grid for most everything else with an edit button that
opens another window with a screen to edit the record. What I would like to
do is display all the objects in a grid an then have a drop down list on
each record that shows all of the people that requested the object and let
the user select the one user that gets it. But I can't figure out how to do
this that isn't very database intensive. There are a couple hundred objects
and about a hundred users. Thanks for nay help you can offer.
vb.net and asp.net. It is using a SQL 2000 database. I have a list of
objects in a table that looks something like this:
ID ObjectName PropName PropName2 PropName3
1 Object 1 Property1 Property2 Property3
Then I have a fairly basic user table with a userid for each user. The
users login and request objects. When they request an object, I add a
record to another table with the ID # of the object, the ID # of the user
and the time and date they requested it. Now the administrative people need
to login and assign the object to one of the people that requested it. I
can't figure out how to display the data and take the user input. I have
been using a data grid for most everything else with an edit button that
opens another window with a screen to edit the record. What I would like to
do is display all the objects in a grid an then have a drop down list on
each record that shows all of the people that requested the object and let
the user select the one user that gets it. But I can't figure out how to do
this that isn't very database intensive. There are a couple hundred objects
and about a hundred users. Thanks for nay help you can offer.