We'd need to know how you've set up your fields, tables and relationships in detail to be able to answer you in detail.
It sounds like "Jane DOE" comes from one record and "(John) DOE" comes from another.
Without knowing those details, I'd guess that an If or case function can be set up inside your calculation that swaps the first name order based on which name, if any, comes from a non-member record.
Yes, each adult is in a separate record within the "adults" table. There is a field called "status" that indicates whether they are a member or not.
And what is the calculation you are currently using to combine the names like this?
In the Household table the calculation is:
Upper ( Household Name ) & ", " & Substitute ( List ( Adults::Directory name ) ; ¶ ; " and " )
In the Adults table there is a calculation to generate the parentheses for non-members:
If ( Status = "Non-member spouse/partner of member"; "(" & Name preferred & ")";
If ( Status = "Attending Adult Non-member"; "(" & Name preferred & ")";
If ( Status = "Pastor"; "(" & Name preferred & ")")))
a calculation for members:
If ( Status = "Active Adult"; Name preferred; If ( Status = "Matriculating College Student"; Name preferred; ""))
and a calculation to combine the two:
Directory name for members & Directory name for nonmembers
I'm thinking this is a little cumbersome, but it's the only way I could get it to work.
I suggest looking up Case in FileMaker help as this can simplify your calculations by eliminating most of your multiple If functions that you currently have enteredd in a single field definition.
Case ( Status = "Active Adult" ; Name preferred ;
Status = "Matriculating College Student" ; Name Preferred ;
"(" & Name Preferred & ")"
Should do it all in one calculation field.
That said, there seems to be something missing here. I see a calculation for computing the format for the current adult's record who may or may not be a member, but I don't see any calculation here that brings in the spouses name from the related record for the spouse.
That's the expression that will need to be modified if you always want members listed before non-members.
I apologize, I don't understand. Do you mean have the non-member spouses in a separate table from the "adults"? Currently they are all in one table.
The calculations you've posted will compute
But don't include a spouses first name, such as DOE, John and (Jane)
What calculation do you use to produce that entry? That's the one we need to modify if you want to always see the member's first name to the left of a non-member spouse.