Thank you ridders52,
still i have problem - i think any from the provided list is not matched here:
Code:SELECT t_ServerInfo.Sockets, t_CpuOffer.Overhead, t_CpuInfo.Server FROM (t_ServerInfo INNER JOIN t_CpuInfo ON t_ServerInfo.ServerInfo_ID = t_CpuInfo.ServerInfo_ID_FK) INNER JOIN t_CpuOffer ON t_ServerInfo.ServerInfo_ID = t_CpuOffer.ServerInfo_ID_FK;
What is wrong herE?
Best,
Jacek
Using two one to many links likely to be the issue. Try joining two tables and save that.
then make a second query joining the first query and the other table
as Ridders says, queries with multiple tables are generally not updateable. You can try changing the dataset type (see query properties) to inconsistent updates, but updating tables directly in Access is an Excel mindset. Tables should be updated through forms, where the rule is one form, one table with joins represented by using subforms with the linkmaster/linkchild to represent the joins.