Work with dynasets

When you run, or open, a query, the query takes your requests and produces appropriate data in a dynaset, or dynamic subset of your data. The dynaset looks a lot like a table’s datasheet—the only difference is that it can show fields from more than one table, and its data may be filtered and sorted differently than the underlying table(s).

  • When you make changes to a query’s dynaset, those changes are placed into the appropriate fields and records in the underlying tables.
  • When you delete a record from a dynaset, any corresponding records are deleted from the underlying tables.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.