I have 2 tables:
Funds (FundName | Ticker)
Client'sFunds (ClientID | Ticker)

I would like to have a form where a user can add a record to the Client'sFunds table, choosing based on a list of FundNames.

Can i have a combobox that will allow a user to scroll through a list of FundNames, but add Ticker of the selected fundName to the field?