linking 2 tables causes read only issue

[jnewl]

when i link a 1,000,000 record file to another small table to get a
description, it causes a read only issue with the main table, in that, I can
not make any changes.

If i do not link, can make changes. This is a very basic link on a key
field, that have done multi times in other applications. No options are set
to make it read only, so do not know why am being blocked.

suggestions thanks much

 

[bcap]

Presumably when you say "link", what you mean is that you are joining the
tables in a query?

If so, make sure that the query's SELECT list contains the primary keys from
both tables.