Updating Listbox values

salamander

Registered User.
Local time
Today, 04:58
Joined
Mar 3, 2008
Messages
18
Hi there,

I have a listbox which gets a list of resources based on the role they are viewing. So, for illustration sake, it will get all Resources assigned to RoleID = 1 then display them all. Each resource has a daily rate.

So in this example, I have 3 tables, 1 for the roles, 1 for the resources and 1 for assigning the resources to roles with the daily cost.

In this listbox, a user can see a resource's name and cost. I want the user to be able to select a row, and have a textbox next to the listbox which allows them to change that resource's rate and save. This will thus save the cost to the Assign table. So my problem is A) getting the textbox to display the selected resource rate and B) allowing the textbox to update the selected resource rate.

What is the best way of doing this?

Thanks!
 
Managed to do it, using some SQL statements :)

Thanks anyway
 

Users who are viewing this thread

Back
Top Bottom