Looking Up Data - Headings and Subheadings

[DJHDCJ]

Greetings
This may be a very elementary request.
I have a database of references for a thesis I am writing
I want to organise the references by topic heading and by sub-heading.
I have developed a list of topics. Each topic has a number of
subheadings
For example I have a heading entitled Printing Press
and say a couple of subheadings like Invention, Introduction to
England, Caxton
And so on with a whole lot of other headings
What I want to be able to do is to use a table and lookup the heading.
So far so good.
Then in the next field I want to lookup all the subheadings that
relate only to that heading - not so good. At the moment what I get
are ALL the subheadings for all the separate headings.
I can't work out how to just get the particular subheadings for the
relevant heading.
Once I get that part sorted out it is a simple matter to look up the
articles and books
I should be grateful for some assistance

Cheers
DJH

 

[tina]

your table structure is not clear to me. should be two tables, as

tblHeadings
HeadID (primary key)
HeadName

tblSubHeadings
SubID (primary key)
SubName
HeadID (foreign key from tblHeadings)

the relationship is
tblHeadings.HeadID 1:n tblSubHeadings.HeadID

use a form to search for the heading you want, and then the subheading.
there are numerous ways to set this up in a form - depends on how you want
to search, and what is the ultimate objective of the search.

hth

 

[DJH]

Thanks Tina
Just a couple of things
How do I edit the relationship to read "lHeadings.HeadID 1:n
tblSubHeadings.HeadID"

It is the "..1:n" that I am unsure about

Even so I created a table where the heading appears in one box and a
list of the subheadings under that. So far so good.. I click through
the various headings and the subheadings appear. Great!! Many thanks.

What I want to do now is create a table whereby I can lookup the
Headings table to get a heading for one fielld (say we call it
SelectHeading) and then lookup the subheadings table to get the
entries that correspond to the selected heading in the heading field
so that I can put the entry in a second field (say SelectSubHeading).
I have got as far as lookingup the heading and getting that right.
However in the subheading field I get ALL the subheadings for the
various headings.

Once I get that right then I can relate the SelectHeading and the
SelectSubheading to an article or book reference

Cheers
DJH

 

[PC D]

If you set up the tables Tina suggested then you need a form/subform system.
The main form should be based on TblHeadings and the subform based on
TblSubHeadings. Once you have this system built, open the main form in
design view and make sure the LinkMaster and LinkChild fields are both
HeadID. You will then get what you want. When you navigate to any Heading in
the main form, the subform will automatically list the SubHeadings for that
Heading.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)

 

[DJH]

Thanks
That works just fine.
Could you please tell nme where I set up the LinkMaster and LinkChild
Fields.

However the problem still remains in setting up the table where I look
up the heading in one field and then try to find the related
subheadings in another. I still seem to get all the subheadings.

Do I do this by setting up a query or something.

Cheers
DJH

 

[PC D]

LinkMaster and LinkChild properties are set by opening your main form in
design view, selecting the subform control, opening properties and going to
the Data tab.

Setting these properties should take care of your problem!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)

 

[DJH]

Sorry
I must be REALLY thick
I have the main form and the subform set up ok and the Heading and
subheading related references appear.

Now I want to set up another table that will lookup the Heading fields
and then allow me to enter them in and lookup the related subheading
fields and enter them in. At the moment I can do the Heading fields on
the table but all the subheading fields (related and unrelated) appear
in the lookup list.

Then (sorry to be a nuisance) I want to put that table into a form so
I can do all that from the form

Cheers
DJH

 

[tina]

don't do any of that at the *table* level. tables should not be used for
data entry or display. tables simply store data. in Access, *forms* are the
proper tools for viewing/entering/editing data. also, see
http://home.att.net/~california.db/tips.html#aTip6 and
http://home.att.net/~california.db/tips.html#aTip8 for more table
recommendations.

hth

 

[StopThisAdvertising]

PC Datasheet
Your Resource For Help With Access, Excel And Word Applications 'Resource ????
Over 1175 users have come to me from the newsgroups requesting help '1175 users ????
(e-mail address removed)

--
To Steve:

Why PC D this time? Why not PCD anymore, or Access Resource or Help available or why not just PC DataSheet?
You think that changing names is vital for you?
Why don't you just get lost? No-one wants your advertising/job hunting here!
Over 600!! users from the newsgroups have visited the website to read what kind of a 'resource' you are... (rapidly increasing..)

To the original poster:
Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html

Arno R

 

[DJH]

Tina
I have created the two forms that contain the data - the heading info
and the related subheading info

I set up another 2 tables with empty fields for entering the heading
and subheading data into respectively.

I created a form to show the heading and related subheadings - so far
so good

I created a form to enter the data into the new table.
The main form is entitled " heading". The subform is entitled
"subheading"

I changed the text boxes to combo boxes

I ensured that the Linkmaster and Linkchild settings were as suggested

I set up a query whereby the value that appeared in the combo box for
the heading would drop down to all the headings and I click on that.

When I get to the subheadings I am still getiing all the subheadings -
not just the ones that relate to the particular heading.

Sorry to be such a nuisance - I spent all afternoon trying to figure
this one out. I am sure the answer is simple

Cheers
DJH

 

[tina]

okay, i think we're having a basic miscommunication, but i'm not sure just
where. if you'd like me to take a look at your db, post back and i'll tell
you where to get my email address so you can send it to me.

hth

Tina
I have created the two forms that contain the data - the heading info
and the related subheading info

I set up another 2 tables with empty fields for entering the heading
and subheading data into respectively.

I created a form to show the heading and related subheadings - so far
so good

I created a form to enter the data into the new table.
The main form is entitled " heading". The subform is entitled
"subheading"

I changed the text boxes to combo boxes

I ensured that the Linkmaster and Linkchild settings were as suggested

I set up a query whereby the value that appeared in the combo box for
the heading would drop down to all the headings and I click on that.

When I get to the subheadings I am still getiing all the subheadings -
not just the ones that relate to the particular heading.

Sorry to be such a nuisance - I spent all afternoon trying to figure
this one out. I am sure the answer is simple

Cheers
DJH

don't do any of that at the *table* level. tables should not be used for
data entry or display. tables simply store data. in Access, *forms* are the
proper tools for viewing/entering/editing data. also, see
http://home.att.net/~california.db/tips.html#aTip6 and
http://home.att.net/~california.db/tips.html#aTip8 for more table
recommendations.

hth

Sorry
I must be REALLY thick
I have the main form and the subform set up ok and the Heading and
subheading related references appear.

Now I want to set up another table that will lookup the Heading fields
and then allow me to enter them in and lookup the related subheading
fields and enter them in. At the moment I can do the Heading fields on
the table but all the subheading fields (related and unrelated) appear
in the lookup list.

Then (sorry to be a nuisance) I want to put that table into a form so
I can do all that from the form

Cheers
DJH


LinkMaster and LinkChild properties are set by opening your main form in
design view, selecting the subform control, opening properties and

going
to

the Data tab.

Setting these properties should take care of your problem!

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
(e-mail address removed)



Thanks
That works just fine.
Could you please tell nme where I set up the LinkMaster and LinkChild
Fields.

However the problem still remains in setting up the table where I look
up the heading in one field and then try to find the related
subheadings in another. I still seem to get all the subheadings.

Do I do this by setting up a query or something.

Cheers
DJH


If you set up the tables Tina suggested then you need a form/subform
system.
The main form should be based on TblHeadings and the subform based on
TblSubHeadings. Once you have this system built, open the main form in
design view and make sure the LinkMaster and LinkChild fields are both
HeadID. You will then get what you want. When you navigate to any Heading
in
the main form, the subform will automatically list the SubHeadings for
that
Heading.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting
help
(e-mail address removed)



Thanks Tina
Just a couple of things
How do I edit the relationship to read "lHeadings.HeadID 1:n
tblSubHeadings.HeadID"

It is the "..1:n" that I am unsure about

Even so I created a table where the heading appears in one box and a
list of the subheadings under that. So far so good.. I click through
the various headings and the subheadings appear. Great!! Many thanks.

What I want to do now is create a table whereby I can lookup the
Headings table to get a heading for one fielld (say we call it
SelectHeading) and then lookup the subheadings table to get the
entries that correspond to the selected heading in the heading field
so that I can put the entry in a second field (say SelectSubHeading).
I have got as far as lookingup the heading and getting that right.
However in the subheading field I get ALL the subheadings for the
various headings.

Once I get that right then I can relate the SelectHeading and the
SelectSubheading to an article or book reference

Cheers
DJH

 

[tina]

btw, just so there's no confusion, i *am* offering to look at your db for
free, DJH, and give you any suggested solutions that i come up with, for
free - just as i have done for other post-ers on occasion, in the past.
these newsgroups are intended for the free exchange of ideas and assistance
between peers; i have always honored that standard, and i always will.

okay, i think we're having a basic miscommunication, but i'm not sure just
where. if you'd like me to take a look at your db, post back and i'll tell
you where to get my email address so you can send it to me.

hth

Tina
I have created the two forms that contain the data - the heading info
and the related subheading info

I set up another 2 tables with empty fields for entering the heading
and subheading data into respectively.

I created a form to show the heading and related subheadings - so far
so good

I created a form to enter the data into the new table.
The main form is entitled " heading". The subform is entitled
"subheading"

I changed the text boxes to combo boxes

I ensured that the Linkmaster and Linkchild settings were as suggested

I set up a query whereby the value that appeared in the combo box for
the heading would drop down to all the headings and I click on that.

When I get to the subheadings I am still getiing all the subheadings -
not just the ones that relate to the particular heading.

Sorry to be such a nuisance - I spent all afternoon trying to figure
this one out. I am sure the answer is simple

Cheers
DJH

form

in

form

in

and

a

 

[John Marshall, MVP]

btw, just so there's no confusion, i *am* offering to look at your db for
free, DJH, and give you any suggested solutions that i come up with, for
free - just as i have done for other post-ers on occasion, in the past.
these newsgroups are intended for the free exchange of ideas and
assistance
between peers; i have always honored that standard, and i always will.

It is a shame that the action of one individual has forced you to qualify
your offer even though you are offering to do something that is common for
most newsgroup participants.

John... Visio MVP

 

[tina]

well, i wasn't looking to start a flame war in this thread, John - just
clarifying my offer, and my position, to DJH so he can feel comfortable in
accepting my help if he chooses to.

 

[DJH]

Tina
Many thanks
I have seen your subsequent post and appreciate the offer in the
spirit in which it was intended. I am greatly obliged.

You can email me privately at my address (remove the "nospam" from in
from of the domain name - but I don't need to tell you that ).

I look forward to hearing from you.

Cheers
DJH

okay, i think we're having a basic miscommunication, but i'm not sure just
where. if you'd like me to take a look at your db, post back and i'll tell
you where to get my email address so you can send it to me.

hth

Tina
I have created the two forms that contain the data - the heading info
and the related subheading info

I set up another 2 tables with empty fields for entering the heading
and subheading data into respectively.

I created a form to show the heading and related subheadings - so far
so good

I created a form to enter the data into the new table.
The main form is entitled " heading". The subform is entitled
"subheading"

I changed the text boxes to combo boxes

I ensured that the Linkmaster and Linkchild settings were as suggested

I set up a query whereby the value that appeared in the combo box for
the heading would drop down to all the headings and I click on that.

When I get to the subheadings I am still getiing all the subheadings -
not just the ones that relate to the particular heading.

Sorry to be such a nuisance - I spent all afternoon trying to figure
this one out. I am sure the answer is simple

Cheers
DJH

 

[tina]

email sent.

Tina
Many thanks
I have seen your subsequent post and appreciate the offer in the
spirit in which it was intended. I am greatly obliged.

You can email me privately at my address (remove the "nospam" from in
from of the domain name - but I don't need to tell you that ).

I look forward to hearing from you.

Cheers
DJH