Hi
I am constructing a simple data base with 5 tables and a conventional relationship layout. I intend to use queries as the data source for various forms.
My question is:
Do I have an individual query as a data source for a single form and other queries for the sub forms that will be nested within it.
Or do I have the same query linking the tables as the same source for the form and nested subforms.
I hope that's clear.
Thanks in advance.
Steven811 - complete novice
I am constructing a simple data base with 5 tables and a conventional relationship layout. I intend to use queries as the data source for various forms.
My question is:
Do I have an individual query as a data source for a single form and other queries for the sub forms that will be nested within it.
Or do I have the same query linking the tables as the same source for the form and nested subforms.
I hope that's clear.
Thanks in advance.
Steven811 - complete novice