I have written some VBA to create a basic data model in Excel from an Access database. It’s nearly there, but I have found an issue with finding the Foreign keys in tables.
Here is the relationship:
And here are the indexes in table tblSubHeading:
When I use the Relation object the VBA...