Using information captured on another form for dropdown box
HI there,
I have two forms, one with referral data and one with broker data
On the referral form I have a dropdown box which need to create a list of brokers which I create through the broker form
The referral list includes the following fields
Broker: (Dropdown)
First Name: (Single)
Last Name (Sinlge)
The broker list includes the following
First Name (Single)
Last Name (Single)
Thus I need the Broker dropdown in form(Referral) to have List of brokers that was created by through the form(broker)
The list should combine the Last Name and First Name of Broker
ex: form(Broker)
First Name: Koos
Last Name: Roos
form(Referral)
Broker dropdown box: Roos, Koos
Hope someone will be able to assist with this