Fields are locking, but very stange (1 Viewer)

[k0r54]

Hi,

Ok, i have a really stange problem

I have two tables tablea, tableb. They both have the field Line address in which is a number.

However, when i have both these tables in a query and link them on line address the dataview sheet becomes locked. But if i just run a query with tablea on its own, i can write in the dataview and if i just run a query with tableb i can also write in it, but when linked together on line address, it fails

Any ideas?

Thanks
k0r54

 

[k0r54]

Problem solved

Ok problem solved, one of the link fields (Line Address) needs to be a primary key