This might not be the correct Forum, it's crosses over a few. So apologies...
Backend is a MariaDB server (similar to MySQL).
I have a table with a composite key.
The MySQL Workbench shows index:
Key: Primary
Type: BTREE
Unique: YES
Columns: InstallerID, InductTypeID
The Frond End Access 2016 has a linked table.
When I view the table in design mode, the only Key is shown against InductTypeID. It doesn't show as a composite key using multiple columns.
This is causing all sorts of issues with my query results.
Any ideas how to get Access to accept the composite key?
Thanks,
Trav