Are you only allowing one phone number of each type?
If so, you can define three, single row, filtered portals (The implementation details can vary for filemaker 11), one for each column.
In version 10 and earlier, you'd need to define three (or more) relationships, one for each portal.
Here's an example for column 1: Define a calculation field that returns the text "Tel" and call it "cTellKey".
Then your relationship looks like this:
Contacts :: Contact Names = TellNumbers::Contact Names AND
Contacts :: cTellKey = TellNumbers::Category
TellNumbers is a new table occurrence of Numbers.
In filemaker 11, you can simply define a different filter expression for each portal:
For column 1, you could enter Numbers::Category = "Tel"
I understand that this is being used for export? Do you really need columns? If not then you can also try this: In your numbers table define a calculation (result is text) called cCategoryNumber as:
Category & ": " & number
Then from your Contacts table, define calculation (text) as:
Substitute ( List ( Numbers::cCategoryNumber ) ; ¶ ; ", " )
Instead of columns, it will produce list as: Fax: 3441124, Tel: 212747 etc.
As mentioned, if you have vs. 11 and you only have one number of each category, you can create filtered 1-row portal. Place the information (including the 1-row portals) on a list view with only the fields you wish for your 'report' and then Save As Excel. This will grab the filtered portals' values. YOu cannot export filtered portals (they will display first record in relationship and not filtered results).
no, but so far I don't get too many contact that has more than one number per type, I think I can just make the second number different type, ex mobile2
I'll have a try tommorrow
I think this'd work think I just relized I only need one number per type when exporting!
Thanks a lot!