I have 2 tables:
- Organisations - which contains fields related to organisations we have funded to run projects - each record includes the organisation’s postcode
- Projects - which contains fields related to projects run by these organisations.
The 2 tables are linked -a project links to one org and an org can link to multiple projects.
I want to export the project table to csv to create a map of the projects but I need the postcode to be exported too and it’s in the other table. Can I do this? I currently only get the organisation’s name in the csv file as it’s the primary field of the org table. Thanks!