![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
Database Experts?
Can anyone on my flist assist with this question?
If I have four products:
a = $10
b = $20
c = $30
d = $40
I want to create two fields on the form, one a drop down box where the user enters the choice of a, b, c or d. I then want the corresponding field to automatically fill in the price. On the form and on the table of customers.
As far as I have been able to figure out I need my table of customers and then I need my table of products. I can make the drop down box where they choose the product but not make the price appear in the price box.
Help. Please.
If I have four products:
a = $10
b = $20
c = $30
d = $40
I want to create two fields on the form, one a drop down box where the user enters the choice of a, b, c or d. I then want the corresponding field to automatically fill in the price. On the form and on the table of customers.
As far as I have been able to figure out I need my table of customers and then I need my table of products. I can make the drop down box where they choose the product but not make the price appear in the price box.
Help. Please.
no subject
(no subject)
(no subject)