Can I link records together, create Groups and subgroups?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I link records that are related without having to redo a filter each time
- In essence, can I create groups and subgroups of records without having to
create a new data field?
 
It seems you have some experience with excel, right?
With A nice build relational database, everything is possible.

Make 2 tables, "tblData" and "tblGroup".
Each table has (e.g.) a field ID (number, long) and a name (text, varchar).
The 1th table also has a field Group_ID.

Then make a query where you join both tables together;
add both tables and double click on the stars in the tables (to add all
fields)
Then drag Group_ID field to ID field from tblGroup.
Now there exists a link between two tables.

If you generate a report with use of a wizard, the wizard will automatically
ask on which field you want to "group". Choose the "name" of the tblGroup.

Like this the report will automatically have all data in groups.

--

Kind Regards
Damiaan
e: info at dampee.be
w: http://www.dampee.be
 
Back
Top