A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Displaying a table within a table



 
 
Thread Tools Display Modes
  #1  
Old November 10th, 2006, 06:15 PM posted to microsoft.public.access.forms
cs_vision
external usenet poster
 
Posts: 18
Default Displaying a table within a table

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?
  #2  
Old November 10th, 2006, 06:34 PM posted to microsoft.public.access.forms
kingston via AccessMonster.com
external usenet poster
 
Posts: 620
Default Displaying a table within a table

Are you talking about sub-datasheets? You can add another table's related
records to a main table, but at least in AC2000, this only works one table at
a time. To do this, open the main table and select menu option Insert -
Subdatasheet... Choose a related table and the related fields between the
two tables. A column of + signs will appear to the left of the records when
you're done. Clicking on this + will reveal the sub-datasheet.

cs_vision wrote:
I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via http://www.accessmonster.com

  #3  
Old November 10th, 2006, 06:37 PM posted to microsoft.public.access.forms
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default Displaying a table within a table

I'm not completely clear from your description, but it sounds like you are
trying to do this in a table, not in a form.

A check through the tablesdbdesign newsgroup will show a VERY strong
consensus against using lookup data type fields in tables. One major reason
is that the field stores one value, but displays something else. This
causes considerable confusion!

If you have a table that contains "lookup" items, the place to use (and
show) that is in forms.

Or have I misinterpreted?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/


"cs_vision" wrote in message
...
I have a table that I have added fields that contain lookups to other

tables.
How can I display the full table from that field within the main table?


  #4  
Old November 10th, 2006, 06:56 PM posted to microsoft.public.access.forms
cs_vision
external usenet poster
 
Posts: 18
Default Displaying a table within a table

Thanks for your help, I didn't realize this is not what I needed, how do you
remove the subdatasheet?

To explain better, I am trying to create a form from 8 tables. The main
table called documents has client name, attorney, documents, document date
and classification fields. The remaining 7 tables are child tables bound by
the classification field (or so I want them to be). Based on the
classification choosen for each client name, I would like the form I created
for the remaining 7 tables to popup. Each table/form represents a certain
classification.

"cs_vision" wrote:

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?

  #5  
Old November 10th, 2006, 06:57 PM posted to microsoft.public.access.forms
cs_vision
external usenet poster
 
Posts: 18
Default Displaying a table within a table

I did figure out how to remove the subdata sheet.

"cs_vision" wrote:

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?

  #6  
Old November 10th, 2006, 07:56 PM posted to microsoft.public.access.forms
kingston via AccessMonster.com
external usenet poster
 
Posts: 620
Default Displaying a table within a table

Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.
It's clean and easy to implement but might be slow.

cs_vision wrote:
Thanks for your help, I didn't realize this is not what I needed, how do you
remove the subdatasheet?

To explain better, I am trying to create a form from 8 tables. The main
table called documents has client name, attorney, documents, document date
and classification fields. The remaining 7 tables are child tables bound by
the classification field (or so I want them to be). Based on the
classification choosen for each client name, I would like the form I created
for the remaining 7 tables to popup. Each table/form represents a certain
classification.

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via http://www.accessmonster.com

  #7  
Old November 10th, 2006, 08:39 PM posted to microsoft.public.access.forms
cs_vision
external usenet poster
 
Posts: 18
Default Displaying a table within a table

Great, can the existing field "classification" be used as a control for the
tab relating to the classification chosen?

"kingston via AccessMonster.com" wrote:

Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.
It's clean and easy to implement but might be slow.

cs_vision wrote:
Thanks for your help, I didn't realize this is not what I needed, how do you
remove the subdatasheet?

To explain better, I am trying to create a form from 8 tables. The main
table called documents has client name, attorney, documents, document date
and classification fields. The remaining 7 tables are child tables bound by
the classification field (or so I want them to be). Based on the
classification choosen for each client name, I would like the form I created
for the remaining 7 tables to popup. Each table/form represents a certain
classification.

I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via http://www.accessmonster.com


  #8  
Old November 10th, 2006, 08:55 PM posted to microsoft.public.access.forms
kingston via AccessMonster.com
external usenet poster
 
Posts: 620
Default Displaying a table within a table

Maybe I missed something. Does each client get only one classification value
and hence one subform? If so, I'm not sure you should use a tab control; you
can simply stack the subforms on top of each other and turn the appropriate
ones on or off.

Also, I'm not clear on how you wish to use the existing field [classification]
. Do you mean that once it is populated, the corresponding subform will
appear? You can make this happen by using the control's AfterUpdate event to
control individual subform properties such as: .Visible, .Enabled, .Locked.
For example:

Select Case Me.Classification
Case "Class1"
Me.Subform1.Visible = True
Me.Subform2.Visible = False
...
Me.Subform7.Visible = False
Case "Class2"
Me.Subform1.Visible = False
Me.Subform2.Visible = True
...
Me.Subform7.Visible = False
...
End Select


cs_vision wrote:
Great, can the existing field "classification" be used as a control for the
tab relating to the classification chosen?

Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.

[quoted text clipped - 13 lines]
I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via http://www.accessmonster.com

  #9  
Old November 10th, 2006, 09:10 PM posted to microsoft.public.access.forms
cs_vision
external usenet poster
 
Posts: 18
Default Displaying a table within a table

Yes, each client will receive a classification only once and the subform
chosen shows specific information (really a list of questions with answers,
typed in data entry) per classification. I had the classification field from
the main table and thought once I chose the classification for the client,
then a form would popup or be populated on the main form for data entry of
answers from each client.

"kingston via AccessMonster.com" wrote:

Maybe I missed something. Does each client get only one classification value
and hence one subform? If so, I'm not sure you should use a tab control; you
can simply stack the subforms on top of each other and turn the appropriate
ones on or off.

Also, I'm not clear on how you wish to use the existing field [classification]
. Do you mean that once it is populated, the corresponding subform will
appear? You can make this happen by using the control's AfterUpdate event to
control individual subform properties such as: .Visible, .Enabled, .Locked.
For example:

Select Case Me.Classification
Case "Class1"
Me.Subform1.Visible = True
Me.Subform2.Visible = False
...
Me.Subform7.Visible = False
Case "Class2"
Me.Subform1.Visible = False
Me.Subform2.Visible = True
...
Me.Subform7.Visible = False
...
End Select


cs_vision wrote:
Great, can the existing field "classification" be used as a control for the
tab relating to the classification chosen?

Have you considered creating a tab control in your main form? It could have
7 tabs and a subform in each one corresponding to the data in the main table.

[quoted text clipped - 13 lines]
I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via http://www.accessmonster.com


  #10  
Old November 10th, 2006, 09:22 PM posted to microsoft.public.access.forms
kingston via AccessMonster.com
external usenet poster
 
Posts: 620
Default Displaying a table within a table

OK, I understand now. Which method do you want to pursue? Do you want to
use a subform, a tab control with multiple subforms, or a separate form
entirely? In any case, you will use the After Update event of the
classification control of the main form if you are classifying the client for
the first time or reclassifying the client. If the client is already
classified and you simply want to bring up the correct subform, you'll
probably use the main form's OnCurrent event.

Does the code I provided earlier make sense?

cs_vision wrote:
Yes, each client will receive a classification only once and the subform
chosen shows specific information (really a list of questions with answers,
typed in data entry) per classification. I had the classification field from
the main table and thought once I chose the classification for the client,
then a form would popup or be populated on the main form for data entry of
answers from each client.

Maybe I missed something. Does each client get only one classification value
and hence one subform? If so, I'm not sure you should use a tab control; you

[quoted text clipped - 29 lines]
I have a table that I have added fields that contain lookups to other tables.
How can I display the full table from that field within the main table?


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200611/1

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.