thanks Paul, but, I just read the contents of the link you sent me, and this is not what I want. the link basically talks about showing records based on what you choose from the drop down. ie: if USA, show California, Arizona, etc.. IF Mexico, show Baja, Sonora, etc..
I got two fields in my database: Name & ID.
When I choose Name from the dropdown I want a separate READ ONLY field with the Correspoinding ID, or, maybe I need to SHOW BOTH the name & the ID in the same dropdown field.
is it possible?
The link shows you the technique that is required .....you will have to execute a SQL statement to get the specific record indicated by the users selection in the dropdown.