Subdatasheets

[Greg Jesky]

I am using windows 2000 and Access 2000.
I have a question about subdatasheets that will help me greatly during
testing and maybe later..?.
I have a Table called "Common Account Table"
This table contains fields Billing Account No(PK), Contract Id, Service
Provider, etc.. The Billing Account Number is the primary key.

I have 2 other tables called "Local Monthly Bill Summary" and "Wireless
Monthly Bill Summary".

The Local Monthly Bill Summary contains fields "Balance Due", "Outstanding
Balance", "Billing Account No", "Bill Date" "Adjustments", etc.

The Wireless Monthly Bill Summary contains very similar fields.

These two tables reflect monthly billing for communications services,
Landline and Wireless..

The Primary keys for these 2 tables are "Billing Account No" and "Bill Date"
There is a 1 to many relationship between the "Common Account Table" and the
2 Monthly tables.

Is there any way to establish multiple subdatasheets when I access the
"Common Account Table" ?

Presently I can open the + and see monthly billing for only the Table
"Wireless Monthly Bill Summary "
Is there anyway to open all + and have access display the correct
information from both tables??

I hope I have not confused everyone.
Greg

 

[Duane Hookom]

I believe most experienced Access developers:
-avoid all subdatasheets by setting them all to [None]
-avoid creating tables and fields with spaces in the names
-avoid creating two tables with very similar structures where one table
could function properly

 

[John Vinson]

The Local Monthly Bill Summary contains fields "Balance Due", "Outstanding
Balance", "Billing Account No", "Bill Date" "Adjustments", etc.

The Wireless Monthly Bill Summary contains very similar fields.

Any time I see two tables with "very similar fields" I have to wonder:
should these be combined into one table, with perhaps a field
indicating whether this particular record is landline or wireless?

These two tables reflect monthly billing for communications services,
Landline and Wireless..

The Primary keys for these 2 tables are "Billing Account No" and "Bill Date"
There is a 1 to many relationship between the "Common Account Table" and the
2 Monthly tables.

Is there any way to establish multiple subdatasheets when I access the
"Common Account Table" ?

No.

As Duane notes, you should not be using table datasheets AT ALL. They
are NOT designed for data display or data entry; they are data storage
repositories.

What you can do is create a Form based on your Common Account Table,
and put one (or two, or a dozen if need be) Subforms on the form,
based on the related tables.

If you do combine the two Monthly tables into one, you can (if you
wish) use two subforms, each based on a Query selecting a subset of
the data.

John W. Vinson[MVP]