Export One to many relationship using query to excel

[naseerrahaman]

Hi Team,

I am a newbie and trying to build one to many relationship and export the same using query to excel but not able to achieve.

Example of output has been attached in excel format.

Request you to kindly Help and advise.

Thank you.

Regards,


Rehaman.

[June7]

You won't get the blank cells. The master data will repeat.

However, a report can export without the master data repeated. Set textbox HideDuplicates to yes.

But why would you not want the master data on each line on a spreadsheet?

Why are you using table A Field1 as primary key instead of the autonumber ID?

[naseerrahaman]

Hi June7,

thank you so much for attending my post.

I thought there might be a option but no worries i will go with your advise.

once again thank you so much for the help.

Regards,
Rehaman.