When I configure a Layout lookup to grab values from another table, and I choose to have it display two fields instead of just the first one, it still seems to insert both values in the field that has the lookup assigned to it. This happens in spite of what I read here in the FMPro 9 Advanced help:
" Note During data entry, a value list that displays values from two fields still only enters data from the first field specified in step 6. The second field in the value list is for display only, and its value is not entered into any field."
I'm obviously missing something here.