Multiple Table Query - Can't Add/Update

[sucoyant]

Good day all!

My database schema looks like this:

I made a query that included everything, but I can't add or even edit anything in the query results.

What am I doing wrong?

Thanks in advance!

________________________________________

Buddha. Dharma. Sangha.

 

[Golom]

What do you mean by "... a query that included everything ..."?

"Prepared" and "File" appear to be link-tables (i.e. many-to-many relationships) so its most likely that any query that draws data from both sides of those tables will be non-updatable.

Post the SQL for the "everything" query.

 

[BNPMike]

I'll bet you put referential integrity all over the place as well.