CODEWITHSUNDEEP
ms-access
rookie
rookie

Reputation: 2923

Microsoft Access: create subdatasheet with SQL command?

Microsoft Access supports "subdatasheets"

enter image description here

Is it possible to create this type of table from a SQL command? Or does one have to manually point and click to do it.

Upvotes: 2

Views: 358

Answers (1)

Mark C.
Mark C.

Reputation: 6460

SQL commands can run scripts/manipulate data and organize it. It's a declarative language. What you're referring to is part of Access' UI features/capabilities.

Your subdatasheet link shows an Orders table with a 1:M relationship to an Order Details table. One Order record with many details about that Order.

The reference you linked shows you how to set this up; it doesn't take any SQL or even VBA to do this. This is a way to view data and it's correlated data from another table in a Datasheet view.

Upvotes: 3

Related Questions