Form manipulation error

[witooldas]

Hi there,
I have a problem with my split form. In databbase I have tables like:

“Register of orders“ – holding Register_ID, Shop_ID, comments and etc..
“Additional information” – holding ID, Register_ID, company and other info.
“Data” – holding ID, Shop_ID, address and other info.

When I create query which “select” “Register of orders“ with “Additional information” table by Register_ID and creating splint form which show me [Register of orders].ID, [Register of orders]. Shop_ID, [Register of orders]. Comments, [Additional information].company and below table with all existing records. It works normally. I can add, remove or update records.


But when I add to query which “select” “Register of orders“ with “Additional information” table by Register_ID, and “Register of orders“ with “Data” table by Shop_ID and trying to display [Data].adress, then I can’t remove, update or add record. Why?

[jgelpi16]

In your second query do you have a "Group By" in any of your "Total" rows?

[witooldas]

I used "left join"

[jgelpi16]

Are you writing SQL, or using the Query builder in Access? If you have any fields with a "Group By" as the "Total" property you will not be able to edit any records within those results.

[witooldas]

I used Query builder, but "Total" row is blank maybe something wrong with "Data" table? but if it not connected i can easily add, remove or update "Data" table...

SELECT
[Register of orders].*,
[Additional information].*,
[Data].Adress
FROM ([Register of orders] LEFT JOIN [Additional information] ON [Register of orders].ID = [Additional information].ID) LEFT JOIN [Data] ON[Register of orders].X = [Data].X;

Are you writing SQL, or using the Query builder in Access? If you have any fields with a "Group By" as the "Total" property you will not be able to edit any records within those results.

[jgelpi16]

So in your second query you are using two separate tables, correct? If you are using two separate tables you need to setup a relationship between primary key fields in the "Relationships" area.

[witooldas]

All connections are correct I think i found the problem:
"Data" table was created by import records from Excell file. So now i created a new "Data" table and by copy/paste insert all records and it work now with the same sql "select" i can and add/update/delete records

Thanks

So in your second query you are using two separate tables, correct? If you are using two separate tables you need to setup a relationship between primary key fields in the "Relationships" area.