View Single Post
Old 05-25-07, 03:59 PM   #3
ViN86
 
Join Date: Mar 2004
Posts: 15,486
Default Re: Need help with updating entries automatically...

Quote:
Originally Posted by Sazar
Do you have a lookup table?

/me is thinking in terms of sql.

If so, you SHOULD be able to have updated data on the drop-down menu depending on what the table's contents consist of.
yes im using mysql to retrieve the companies and projects (projects are linked to the companies table).

im referring more to actually updating the projects list when the company list item is changed.

say i have companies:

A with projects 1,2,3
B with projects 4,5,6
C with projects 7,8,9

A is initially set and projects 1,2,3 are displayed. i want the project list to be changed to 4,5,6 as soon as the company list is changed to B. how would i do that?
ViN86 is offline   Reply With Quote