Forms and Reports

[nacho]

Hi,


Just wanted to ask what's best:
Forms for tables
Reports for queries
OR
Reports for tables
Forms for queries
__________________
Thanks.

[ConneXionLost]

Neither.

While there is the occasional exception, Queries should generally be the conduit between Tables and Forms/Reports.

Cheers,

[nacho]

Neither.

While there is the occasional exception, Queries should generally be the conduit between Tables and Forms/Reports.

Cheers,

thanks, but it's just that a section of my task says i need to create a form for each table and report for each query, however when i do this, an undesired result comes up, eg
The form for each table, only shows details about one row and not all
The report however displays everything about the query, this is why i am confused.

[ConneXionLost]

That is a function of the form, not the source.

Forms may display data as:

- a "Single Form" (one record at a time);
- a "Continuous Form" (a scrolling form); or
- a "Datasheet view" (much like a table).

You'll find this option in the form design properties.

Cheers,