Forum Discussion
Solved
Can no longer edit queries after Table divide
I'm sure this is a simple resolution but probably above my intermediate Access skills in terms of quickly identifying/troubleshooting. I had a table, that over time, had grown to well over 90 fie...
Hi,
- You can have 32 indexes in a table. With just 90 fields you would have to have a very special use case to need so many indexes. Also be sure to not have duplicate indexes as e.g. Access already creates a hidden index on the foreign key field in every relationship.
- In order for the query to be updatable your common field RPATSID should have a unique index in all 3 tables.
Servus
Karl
*********
http://AccessDevCon.com
Access FAQ (German/Italian): http://donkarl.com
Hi,
- You can have 32 indexes in a table. With just 90 fields you would have to have a very special use case to need so many indexes. Also be sure to not have duplicate indexes as e.g. Access already creates a hidden index on the foreign key field in every relationship.
- In order for the query to be updatable your common field RPATSID should have a unique index in all 3 tables.
Servus
Karl
*********
http://AccessDevCon.com
Access FAQ (German/Italian): http://donkarl.com
Karl_DonaubauerThanks so much Karl! I don't know how I didn't notice I had RPATSID set to "Yes (duplicates OK)" when I recreated the tables. Everything is working great now after following your instructions! Your help is greatly appreciated 🙂