Newbies cweihrauch Posted July 22, 2011 Newbies Posted July 22, 2011 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 Posted July 22, 2011 Posted July 22, 2011 You would export from the join table, and include any related fields that you need from either parent.
comment Posted July 22, 2011 Posted July 22, 2011 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.
Recommended Posts
This topic is 4881 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now