Product Suggestions
It would be useful to be able to have middle name as a standard field.
At the moment the options are to include the middle as part of first name or last name or create a custom field.
When using a custom field it isn't possible to show the middle name in between the first and last name.
Fundamentally, requesting first and last names imposes a stereotype that is not culturally inclusive, better people than me have suggested how this should be managed, for example, this seems reasonable from a user perspective, a full name and a prefered name, the prefered name could be used to populate the Salutation field:
Why Your Form Only Needs One Name Field (uxmovement.com)
The discussion below includes a broader discussion but does not really come to a solution for the cultural challenge and from a database perspective is closer to what PS currently has:
design patterns - How should you record a person's name without resorting to "title, first name, surname" fields? - Stack Overflow
It does seem a very strange form layout to request first and last names but make no allowance for "middle" names? In a Customer Relationship Management system, recording the customer's name correctly should be fundamental?
It might be that, in concept (B2B), the customer is the company rather than the individual but people sell to people and it is important to capture how a person should be addressed.