Just developing over a MS Access DB. Changed primary key column from ID to a customer no.
Now, I am having a few issues because there are no key columns on the pages tab. I saw an earlier topic on this suggesting sending the project, but, as so often with the "send us the project" responses, the actual answer is never posted (and that topic is now locked).
I have synched the DB, in the tables page it is recognised with a key against it, and I have linked it to a child/detail table too.
Any ideas?
Ta.
================
SOLVED - it would seem that renaming the key column in the Query with "[No] as CustNo" meant it no longer worked. By removing the AS clause, it then becomes available as a key column.