rhindo
04-19-2006, 01:09 AM
I have a form that posts to a mysql table called 'proposals'.
I have another table called labor that now contains these fields 'code', 'desc' and 'amount'.
I have another table called materials that now contains these fields 'code', 'desc' and 'amount'.
I want to add some fields to the form that posts to proposals so that the salesman can select the labor code from a drop down list and the fields for 'desc' and 'amount' fill in automatically.
I will need 10 of these drop down boxes. So the salesperson can enter 10 labor codes.
I also want the ability to do this for materials. I will need 20 of these drop down boxes. So the salesman can enter 20 materials codes.
Let me know if you need any additonal information
rhindo AT tampabay.rr.com
I have another table called labor that now contains these fields 'code', 'desc' and 'amount'.
I have another table called materials that now contains these fields 'code', 'desc' and 'amount'.
I want to add some fields to the form that posts to proposals so that the salesman can select the labor code from a drop down list and the fields for 'desc' and 'amount' fill in automatically.
I will need 10 of these drop down boxes. So the salesperson can enter 10 labor codes.
I also want the ability to do this for materials. I will need 20 of these drop down boxes. So the salesman can enter 20 materials codes.
Let me know if you need any additonal information
rhindo AT tampabay.rr.com