I have a separate table for contacts, name, email, tel, address, etc.
In the primary field, I enter the person’s name, eg. John Smith.
Having read somewhere useful for the base design to have separate fields for a person’s name, I have added two fields immediately to the right of the primary, field name FN (for first name) and SN (for surname). Each field option Single Select. Which means that whenever I add a record in the primary field I also have to add the person’s first and surname separately to the respective fields.
I sort on primary field and that suits my needs, as in the event not finding instantly does a filter or simple search. But unless there is some benefit to the database set-up evolution in having two separate fields for FN and SN I can’t see any advantage. Is there? and if so then what is it?