I have a question regarding Data Access Pages in Access 2003
To simplify this, let say I have a table VENDORS in my database. The table has fields : VENDOR and RATE. VENDOR is the primary key.
The values in the table are:
VENDOR RATE
Moe 1.5
Larry 2.5
Curly 1.5
If I choose Larry in the dropdown field on the DAP, I want to populate another field on the DAP with the value 2.5 .
How can I do this?
Thank you.
To simplify this, let say I have a table VENDORS in my database. The table has fields : VENDOR and RATE. VENDOR is the primary key.
The values in the table are:
VENDOR RATE
Moe 1.5
Larry 2.5
Curly 1.5
If I choose Larry in the dropdown field on the DAP, I want to populate another field on the DAP with the value 2.5 .
How can I do this?
Thank you.
