www.hkvforums.com

I have a table with first name, second name, and id

These fields are selected from another table then auto fills the fields I need populated.

To make it easier for the user I use the display field 1, display field 2, display field 3.

My problem is that that all 3 fields are saved in the display field 1, how can I save / enter only the first field

Thanks

1. You should normalize the lookup settings so that only the id of the lookup value is saved
2. To auto fill from a select field, you need to specify the correct Auto Fill settings in Lookup Table settings