Multi-dimensional exports

[cweihrauch]

Hi,

I'm sure this has been asked already, but I can't find it. I'm not even sure this is the right place to ask this or what the exact way to call this is.

I have a FM Telephone directory with 3 tables:

- telephone number

- person

As the two tables are in a many-to-many relationship, i have a third telephone_person table which links the two. As I have 2 categories of users, I have a second table, telephone_person2 to link the phones to the 2nd category of user.

I now need to export this database as a csv and need all records with all possible combinations in a single sheet. A multi-dimensional report, so to speak

For example

Telephone table

id number

1 - 123456

2 - 234567

3 - 345678

4 - 456778

person table

id name

1 - ann

2 - bob

3 - charlie

4 - doris

telephone_person table

tel_id person_id

1 - 2

2 - 1

3 - 3

4 - 2

telephone_person table

tel_id person_id

3 - 1

1 - 4

The export of the above should look like this:

telephone name

123456 - bob

123456 - doris

234567 - ann

345678 - charlie

345678 - ann

456789 - bob

Thanks !

[edit: I added '-' between the values as my formatting got lost]

[bcooney]

You would export from the join table, and include any related fields that you need from either parent.

[comment]

If you want to export each combination as a single field containing "Name - Phone", define a calculation field in the telephone_person table =

person::name & " = " & Telephone::number

and export only this field. Not sure why you would prefer this over exporting name and phone in individual fields, though.

A multi-dimensional report, so to speak

Actually, this is called a flat table.