Ygthkb

Can someone explain European graduate programs in STEM fields?

Have any astronauts or cosmonauts died in space?

How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?

Are all power cords made equal?

1990s-2000s horror alien movie with slugs infecting people through the mouth

Missing a connection and don't have money to book next flight

Question from the 2011 IMC key stage III paper, about determining which number has to be removed, so the multiplication is the square of an integer

How can I handle players killing my NPC outside of combat?

Why don't you get burned by the wood benches in a sauna?

When does a person lose diplomatic status?

If we can’t finish all tasks, does this mean we are doing Scrum wrong?

Does Plato's "Ring of Gyges" have a corrupting influence on its wearer?

Is the Maximum Use License for Everybody (MULE) a FOSS license?

Is it possible to narrate a novel in a faux-historical style without alienating the reader?

What does "move past people" mean in this context?

Including proofs of known theorems in master's thesis

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

"Those books belong to him, don't they / aren't they?" – tag questions for state verbs

Disk space full during insert, what happens?

How can I prevent an oracle who can see into the past from knowing everything that has happened?

Why can all solutions to the simple harmonic motion equation be written in terms of sines and cosines?

Linearity Assumption

How many diagrams is too much in a research article?

Isn't a semicolon (';') needed after a function declaration in C++?

Unique Records property in Delete Query

Unable to add records to query in Access 2007Distinguishing Records with Related FieldsAccess 2010 Need help connecting/updating database dataHelp with Access many-to-many relationship (beginner)How can I allow part of a key to be null and enforce uniqueness of records with nulls?Table Relationships: Table 1 (Field 7, Field 8, Field 9) to Table 2 (Field 1)MS Access Many-Many Query/Form AssistanceDesign a relational database (Access) that identifies breaches in records based on user defined limitsSystem resource exceeded MS Access 365Access Field Data Type Changed

0

In Microsoft Access, if you create a delete query based on two or more related tables, you must open the Property Sheet and set the Unique Records property to "Yes". If you leave it set to "No", you get the error message "Could not delete from the specified tables".

Now, I know how to make the delete query work (by changing the Unique Records property). What I don't understand is why. Why does that property have to be set to "Yes"? What does that change about the delete query? What problem is caused by leaving it as "No"? If you could explain why setting that process is needed, I would greatly appreciate it.

Thank you.

ms-access

share

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

In Microsoft Access, if you create a delete query based on two or more related tables, you must open the Property Sheet and set the Unique Records property to "Yes". If you leave it set to "No", you get the error message "Could not delete from the specified tables".

Now, I know how to make the delete query work (by changing the Unique Records property). What I don't understand is why. Why does that property have to be set to "Yes"? What does that change about the delete query? What problem is caused by leaving it as "No"? If you could explain why setting that process is needed, I would greatly appreciate it.

Thank you.

ms-access

share

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

In Microsoft Access, if you create a delete query based on two or more related tables, you must open the Property Sheet and set the Unique Records property to "Yes". If you leave it set to "No", you get the error message "Could not delete from the specified tables".

Now, I know how to make the delete query work (by changing the Unique Records property). What I don't understand is why. Why does that property have to be set to "Yes"? What does that change about the delete query? What problem is caused by leaving it as "No"? If you could explain why setting that process is needed, I would greatly appreciate it.

Thank you.

ms-access

share

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Paul de BarrosPaul de Barros

1012

New contributor

Paul de Barros is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Paul de BarrosPaul de Barros

1012