J
jc.vega
I'll try to explain this as best as I can.
I have a drop down control on my form that pulls shows three values from a
linked table. The drop down will show [ SSN, First Name, Last Name]. It will
obviously only store what ever value I tell it to use.
My question is this, if I pick a item from the list and when selected it
stores the SSN in the database field is there anyway to pull that persons
First Name and Last Name from the linked table and drop it into two empty
form fields?
The reason is is this, there are existing clients listed in a current
database which we want to access so there is no need for extra data entry,
but we need the blank form fields in the new database available to enter in
new clients.
Man, I hope that makes sense.
I have a drop down control on my form that pulls shows three values from a
linked table. The drop down will show [ SSN, First Name, Last Name]. It will
obviously only store what ever value I tell it to use.
My question is this, if I pick a item from the list and when selected it
stores the SSN in the database field is there anyway to pull that persons
First Name and Last Name from the linked table and drop it into two empty
form fields?
The reason is is this, there are existing clients listed in a current
database which we want to access so there is no need for extra data entry,
but we need the blank form fields in the new database available to enter in
new clients.
Man, I hope that makes sense.