Populate Drop Down

[lawrencepepper]

Never mind,

Fixed.

Thanks again for the help.

L

[jasecorn]

I’m using this method to populate a drop-down.
I was wondering if it’s possible to extend this further by auto filling another field via an SQL query based on the value selected in the drop-down.

For example;
SQL table contains products, and I have these populate the drop down.
Another field in the table contains whether the product is in stock or out of stock.
I want a separate field in the form to populate the stock status.

I know I could display the stock status next to the product in the existing drop down with a CONCAT query, but I specifically want it to populate a different field. My reasoning is that I want to save this data into a completely different database table, and the two values need to be in different SQL columns. A CONCAT would put them into the same column.

Would this be possible?

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[movisart]

Why can’t i see the replies to this topic?

[movisart]

this too!?

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

• This reply was modified 9 years, 2 months ago by Ally.

[Author]

Posts