Enter number get text

On Tue, 16 Aug 2005 03:12:06 +1200, Steve Schapel wrote:

Husky,

Well, I did try to explain it before. I said:
"It seems to me that both the tables you have described relate to the
same information... each record is information about one Episode, am I
right? If so, the two tables should be combined. If you have Episode
field as the primary key, it means that this can not be duplicated... is
this what you intended? I at first imagined that this referred to an
episode number of a particular series, so for example each Title might
have an Episode 1, Episode 2, etc. But apparently not? In that case,
you can make your Episodes table like this...
Episode
Tape_Number
Title
Air_Date
Prod
Season
Num
Notes
... and that's it! From this information, you should be able to get
your list of Episodes on each Tape, plus be able to easily locate which
Tape contains which Episode, or which Tapes contain Episodes of which
Titles, etc."

You did not appear to respond to this, so I guess that means you didn't
understand it, so my apologies. So here's the core of it. There are
certain principles that need to be applied to creating a database. One
is that the same information should not be replicated in different parts
of the data structure. Another is that a separate table should be used
for each subject that you are managing data about. You determine this
by asking this question about a table: "What does each record in this
table describe?" Unless I am misunderstanding you, each record in your
Episodes table describes an episode of a show.
Yes
And each record of your VCRs table describes an episode of a show.

Actually the vcr table describes ALL the episodes found on that one VCR tape.
There's about 19 tapes with 8-15 episodes per tape.
But it creates a record for each episode. ie: episode 1 on tape 1, 4, and 5. 3
entries in the VCR sub form for the same episode
For each VCR record, the title, and tape number change.

Please correct me if I am
wrong. In which case you will need to provide some examples of the data
so I can see what's going on. But otherwise, just make one table, which
combines the fields which you use from the two existing tables.

Actually, I Barney Googled it.
I have a sub form within a form that access created by using the 2 tables, and
fields from each table.

It fills in the episode number in the vcr list, but it'd also be nice if it
filled in the title also.

As for combining, I want the 2 separate tables. I'm using a form to fill in the
blanks for the VCR list. Maybe it might be simpler to just add a field to the
episode table for the vcr number, but that might not take into account that
there's sometimes copies of the same episode on more than one tape.
Where for some reason this form + sub form does let me enter the same episode
more than once.

Do you want me to send the tables ?, form or what ?
and where..

--
more pix @ http://members.toast.net/cbminfo/index.html

On Mon, 15 Aug 2005 22:20:36 -0400, Husky wrote:

On Tue, 16 Aug 2005 03:12:06 +1200, Steve Schapel wrote:

Husky,

Well, I did try to explain it before. I said:
"It seems to me that both the tables you have described relate to the
same information... each record is information about one Episode, am I
right? If so, the two tables should be combined. If you have Episode
field as the primary key, it means that this can not be duplicated... is
this what you intended? I at first imagined that this referred to an
episode number of a particular series, so for example each Title might
have an Episode 1, Episode 2, etc. But apparently not? In that case,
you can make your Episodes table like this...
Episode
Tape_Number
Title
Air_Date
Prod
Season
Num
Notes
... and that's it! From this information, you should be able to get
your list of Episodes on each Tape, plus be able to easily locate which
Tape contains which Episode, or which Tapes contain Episodes of which
Titles, etc."

You did not appear to respond to this, so I guess that means you didn't
understand it, so my apologies. So here's the core of it. There are
certain principles that need to be applied to creating a database. One
is that the same information should not be replicated in different parts
of the data structure. Another is that a separate table should be used
for each subject that you are managing data about. You determine this
by asking this question about a table: "What does each record in this
table describe?" Unless I am misunderstanding you, each record in your
Episodes table describes an episode of a show.
Yes
And each record of your VCRs table describes an episode of a show.

Actually the vcr table describes ALL the episodes found on that one VCR tape.
There's about 19 tapes with 8-15 episodes per tape.

Actually to more specific, the episodes table, is just a reference table.
Reference for the episode number, and title. I also have a text episode guide
open in a text window that gives me the description of each episode.
I find the episode by searching the text for specific words to describe each
episode ie: search term 'woodpecker' finds 'the wood, the bad, and the ugly'
episode. From that description I now have both the episode number title, and
description to enter into the VCR table.
with the episode table [reference only] and the vcr sub table form, I hit the
episode number in the GO TO box, then enter the description, title, and VCR
number into the VCRs sub table form. This updates the VCRs table.
I'm just saying that since I am sort of combining both the VCRs and episode
tables into one form, there should be a way when I enter the episode number
into the episode form GO TO box, it should be able to fill in the episode
number AND title automatically in the VCRs sub form.
But it only fills in the episode number. into the VCRs sub form.
episode number is the key [not auto number] in episodes table,
videocollectionID [auto number, irrelevant number] is the key in VCRs table.

But it creates a record for each episode. ie: episode 1 on tape 1, 4, and 5. 3
entries in the VCR sub form for the same episode
For each VCR record, the title, and tape number change.

Please correct me if I am
wrong. In which case you will need to provide some examples of the data
so I can see what's going on. But otherwise, just make one table, which
combines the fields which you use from the two existing tables.

Actually, I Barney Googled it.
I have a sub form within a form that access created by using the 2 tables, and
fields from each table.

It fills in the episode number in the vcr list, but it'd also be nice if it
filled in the title also.

As for combining, I want the 2 separate tables. I'm using a form to fill in the
blanks for the VCR list. Maybe it might be simpler to just add a field to the
episode table for the vcr number, but that might not take into account that
there's sometimes copies of the same episode on more than one tape.
Where for some reason this form + sub form does let me enter the same episode
more than once.

Do you want me to send the tables ?, form or what ?
and where..

--
more pix @ http://members.toast.net/cbminfo/index.html

Husky,

To be honest, I don't know how to use database software like Access
according to Barney Google. The only way I know how to use it reliably
is to carefully consider the nature of the information you want to
manage, and the relationships between the various elements of the
information, and design the database accordingly. It now appears that
you can have more than one copy of the same episode on different tapes.
That means there is a one-to-many relationship in your data between
Episodes and Recordings. I am not sure whether you need a separate
table for VCRs or not... this would only apply if you wanted to record
information specific to each VCR, which so far does not seem to be the
case - this would only involve relatively trivial stuff like Brand,
Length, CoverColor, etc. So, it seems to me that you need these tables:

Table: Episodes
Episode
Title
Air_Date
Prod
Season
Num
Notes

Table: Recordings
RecordingID
Episode
Tape_Number

--
Steve Schapel, Microsoft Access MVP

Husky wrote:
Actually the vcr table describes ALL the episodes found on that one
VCR tape.
There's about 19 tapes with 8-15 episodes per tape.
But it creates a record for each episode. ie: episode 1 on tape 1, 4, and 5. 3
entries in the VCR sub form for the same episode
For each VCR record, the title, and tape number change.


Please correct me if I am
wrong. In which case you will need to provide some examples of the data
so I can see what's going on. But otherwise, just make one table, which
combines the fields which you use from the two existing tables.


Actually, I Barney Googled it.
I have a sub form within a form that access created by using the 2 tables, and
fields from each table.

It fills in the episode number in the vcr list, but it'd also be nice if it
filled in the title also.

As for combining, I want the 2 separate tables. I'm using a form to fill in the
blanks for the VCR list. Maybe it might be simpler to just add a field to the
episode table for the vcr number, but that might not take into account that
there's sometimes copies of the same episode on more than one tape.
Where for some reason this form + sub form does let me enter the same episode
more than once.

Do you want me to send the tables ?, form or what ?
and where..

On Wed, 17 Aug 2005 06:37:17 +1200, Steve Schapel wrote:

Husky,

To be honest, I don't know how to use database software like Access
according to Barney Google. The only way I know how to use it reliably

Do a web search for Barney Google.

is to carefully consider the nature of the information you want to
manage, and the relationships between the various elements of the
information, and design the database accordingly. It now appears that
you can have more than one copy of the same episode on different tapes.
That means there is a one-to-many relationship in your data between
Episodes and Recordings. I am not sure whether you need a separate
table for VCRs or not... this would only apply if you wanted to record
information specific to each VCR, which so far does not seem to be the
case - this would only involve relatively trivial stuff like Brand,
Length, CoverColor, etc. So, it seems to me that you need these tables:

Table: Episodes
Episode
Title
Air_Date
Prod
Season
Num
Notes

Table: Recordings
RecordingID
Episode
Tape_Number

Well I'm going with what I have, I'm almost done anyway's. There were only
about 19 total VCR's to catalog. Little extra work copying the title, and
description. And I'll be done before I can figure out how to get it to do
exactly what I want, but with the 2000 Access encyclopedia on hand, I'll have
time to browse deeper and see if it can be done when I finish this cataloging..
--
more pix @ http://members.toast.net/cbminfo/index.html

Fair enough, Husky.

--
Steve Schapel, Microsoft Access MVP

Well I'm going with what I have, I'm almost done anyway's. There were only
about 19 total VCR's to catalog. Little extra work copying the title, and
description. And I'll be done before I can figure out how to get it to do
exactly what I want, but with the 2000 Access encyclopedia on hand, I'll have
time to browse deeper and see if it can be done when I finish this cataloging..

On Wed, 17 Aug 2005 17:53:48 +1200, Steve Schapel wrote:

Fair enough, Husky.

Did you find out who Barney Google is or how it relates to my comment ?

Could have said Murphie'd [as in Murphy's law(s)] it. But that's more of a
pessimists view.

--
more pix @ http://members.toast.net/cbminfo/index.html

Husky,

I already knew what you meant. Did you understand what I meant? You
have come to a forum about building databases to ask the assistance of
those who are experienced in building databases. Let's say this is a
forum about flying helicopters and you don't know nuttin' about flying
helicopters and you come here to ask the advice of people who are
experienced in flying helicopters... and then you decide to try and take
off backwards into a 40mph northerly according to Barney Google. Well,
good luck. :-)

--
Steve Schapel, Microsoft Access MVP

Husky wrote:

Did you find out who Barney Google is or how it relates to my comment ?

Could have said Murphie'd [as in Murphy's law(s)] it. But that's more of a
pessimists view.

On Thu, 18 Aug 2005 09:09:30 +1200, Steve Schapel wrote:

Husky,

I already knew what you meant. Did you understand what I meant? You
have come to a forum about building databases to ask the assistance of
those who are experienced in building databases. Let's say this is a
forum about flying helicopters and you don't know nuttin' about flying
helicopters and you come here to ask the advice of people who are
experienced in flying helicopters... and then you decide to try and take
off backwards into a 40mph northerly according to Barney Google. Well,
good luck. :-)

You didn't google Barney Google.

In long terms, to replace the Barney google reference, I was saying that
"somehow without trying I got the form to do almost what I wanted by pure
accidental dumb luck."
or
I Barney Googled the thing.

I used the page showing the different ways how to try what I'm doing. Didn't do
what I wanted.

IOW: there's information [title and episode number] on the episode guide table,
that I wanted on the VCR table once I finished the cataloging.

The form that came out filled in the episode number ONLY. And I suspect that
was by the relationship settings. I tried adding Title from episodes to
movie_title in vcrs as a relationship, but it seemed it could only handle a
single relationship line.

--
more pix @ http://members.toast.net/cbminfo/index.html

Husky,

I apologise that I don't seem to be able to get my meaning through to
you. At the risk of flogging an extremely dead horse...

1. No, I didn't google Barney Google, I didn't need to, I knew what you
were referring to all along.

2. My point is this: Do you want to continue on the basis of "somehow
without trying ... by pure accidental dumb luck", or do you want to do
it properly?

--
Steve Schapel, Microsoft Access MVP

You didn't google Barney Google.

In long terms, to replace the Barney google reference, I was saying that
"somehow without trying I got the form to do almost what I wanted by pure
accidental dumb luck."
or
I Barney Googled the thing.

On Fri, 19 Aug 2005 09:07:26 +1200, Steve Schapel wrote:

Husky,

I apologise that I don't seem to be able to get my meaning through to
you. At the risk of flogging an extremely dead horse...

1. No, I didn't google Barney Google, I didn't need to, I knew what you
were referring to all along.

2. My point is this: Do you want to continue on the basis of "somehow
without trying ... by pure accidental dumb luck", or do you want to do
it properly?

That's what I bought the access 2000 encyclopedia for. But it wasn't easy to
find the answer I was after. Which is why I asked here.

What I thought was the answer, only mentioned the words 'I forget now', but it
wasn't to be found anywhere in the chapter.

Yes I'd like to be able to take the contents of related fields in 1 table, and
automatically have them copied to related fields in a form I use to update a
2nd table.

in simplest terms.
table 1, field: title copy to table 2, field :VCR title when I enter the
episode number that defines the similar records.

table1 table2
tables episodes VCRs
_______________________________________
field1 episode episode
field2 title movie_title
field3 tape_number --unique
field4 notes --unique

The current form has all the fields of table1, and a sub form of table2 with
all fields. When I entered the episode in the form for table1, it auto filled
in the episode number in the sub form. I had to copy the title from the top of
the form in table1, to the movie_title field in the sub form of table2.
I have since created a new table1, that ALSO includes the notes/description of
each episode.

FWIW: I've finished the cataloging. except for one tape that I haven't found
yet, so far. Last years hurricane scattered everything.

But I have found a lot of unlabeled tapes that I now need to label, so this
will be an ongoing project even if it is no longer about Home Improvement.

And what the hey, learning how to copy more than 1 field to an identical field
in a sub form, or secondary table automatically, simply by entering 1 of the
related fields should be a useful function.

As for reading this encyclopedia, There's 1300+ pages. It's going to take some
time. It's over two inches thick.


--
more pix @ http://members.toast.net/cbminfo/index.html