The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+database+training - A table within a table

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

access+database+training - A table within a table

Resolved · Low Priority · Version Standard

ReplyTue 9 Jan 2007, 09:18Delegate Emily said...

A table within a table

Hi

Could you tell me whether it is possible to add a table within a table. Being able to click on certain fields and open up new information on that particular field.

I have been working on a table like that for some time but did not create it myself so am struggling to know how!

Thanks

For upcoming training course dates see: Pricing & availability

ReplyWed 10 Jan 2007, 10:35 Edited on Wed 10 Jan 2007, 10:35Trainer David said...

RE: A table within a table

Hi Emily

I would create two separate tables, then create a relationship between the two. This is the easiest way of achieving what you want within access. It is possible to create nested tables within databases, but with access I would stick to creating two separate tables.
You will need to create a unique ID in table 1 and use this same ID within table 2, so that you can create a relationship.

To create a relationship between two tables you need to go to the menu, go to tools, click relationships. That will open a new window, add both the tables to the relationship window. Click the unique ID in table 1 and drag this to the identical field in table 2.

Hope this helps

David

ReplyWed 10 Jan 2007, 10:56Delegate Emily said...

RE: A table within a table

Hi David

Thanks for this, i've worked out that if I play around for long enough I can work it out and I have managed to link my tables.

I have another question now! I have created some drop down menu's on a number of my fields in my table. From one of the fields once I select one of the drop down items on the menu I would only like to view certain drop down menu for a couple of the other fields. I have been told this is possible but don't know how to do it. There are 3 different selections of drop down menu's that I would like.

Hope this is clear but am struggling to explain exactly what I want to do.

Thanks,

Emily

Access articles

· Microsoft Access Flaws and Ways to Overcome Them
· Microsoft Access Mistakes to Avoid
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Microsoft Access 2007: New Features
· How Access Can Provide The Key To Successful Stock Management

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips

Can someone please explain the difference between count and counta formulas?

Thanks

» Forum post: COUNT/COUNTA

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions