Extracting addition fields across portals - value list selection set.
It can often be intimidating uploading questions to a forum, after reading several Q&As it makes me realize how little I know about this product! I need help extracting additional data when a user picks a field from a list.
I have a contacts Dbase, and for this example I have created an accountnumber, name, email and division.
In a second database called 'quotes', I have created a value list based on the matching account number. So on the Quote FM project, once they put in the account name, just the names of the contacts appear in the value list. When they select the contact they want, it would be nice to have the contacts 'additional' contact information populate in the secondary fields (white).
What is the best way to automatically extract/include the selected contact's relevant information. So when they pick "Fred Flinstone" from account 1000, Fred's email address and division are extracted from the portal records.
Thank-you in advance.