Hello,
I have a "workshop" report that shows data from my "workshop" form. I also have customer field in my "workshop" form, that data populates from a "customer" form.
I would like my workshop report to produce all my workshop data, and have two fields from the selected customer displayed i.e. Customer Name and Email Address. However I would like these to be listed as two separate columns on the report.
I am sorry if I haven't explained this very clearly, please ask for more information, but does anybody know how I can achieve this?
Thanks in advance,
Simon