Prev: Lists of Commands - stevie is pimping again
Next: "collecting data via email" when recipient uses Hotmail or Yah
From: forest8 on 6 Jan 2010 18:46
Hi there

Yes. Those are some of my tables.



"Gina Whipp" wrote:

> forest8,
>
> Help me out... I have listed a few tables based on your description. What
> am I missing and where/what are the Primary Keys and Foreigh Keys? ith that
> I can lead you in setting up Relationships.
>
> tblStudents
>
> tblEnrollment
>
> tblCourses
>
> tblTeachers
>
> tblSurvey
>
> tblMeetings
>
> --
> Gina Whipp
> 2010 Microsoft MVP (Access)
>
> "I feel I have been denied critical, need to know, information!" - Tremors
> II
>
> http://www.regina-whipp.com/index_files/TipList.htm
>
> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
> news:C4647781-EF5C-44CA-BEAF-8471CA918025(a)microsoft.com...
> > Sorry for the lack of information in the initial question. I've been
> > frustrated by my inability to create relationships.
> >
> > When I try to create a relationship, I seem to be creating an
> > "Indeterminate" relationship. I can't create a one to one or one to many
> > relationship. I get "Intderminate" relationship.
> >
> > I'm tracking enrolment, grades, adds/drops, etc. There is also a survey
> > based on how the students have rated their courses/teachers. As well,
> > there
> > is a table which tracks the frequency and subject of any meetings between
> > student and teachers.
> >
> >
> >
> >
> > "Gina Whipp" wrote:
> >
> >> forest8,
> >>
> >> Going to need to know a wee bit more information. All we know so far is
> >> that you have a Students table, what are the rest of the tables? What
> >> are
> >> you tracking, enrollment, attendence, grades...? You say , "I can't
> >> create
> >> a relationship based on the StudentID.", but you don't say why you fell
> >> you
> >> can't do that.
> >>
> >> --
> >> Gina Whipp
> >> 2010 Microsoft MVP (Access)
> >>
> >> "I feel I have been denied critical, need to know, information!" -
> >> Tremors
> >> II
> >>
> >> http://www.regina-whipp.com/index_files/TipList.htm
> >>
> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
> >> news:5207ABC9-1399-414D-9E6D-739A3DD1C05A(a)microsoft.com...
> >> > Hi there
> >> >
> >> > I've searched through the database and have read about Relationships,
> >> > Primary Keys, and Foreign Keys. But I am still having problems with my
> >> > database.
> >> >
> >> > I currently have a database that has several tables. The primary table
> >> > is
> >> > a
> >> > list of students where their student number is the primary key.
> >> > (StudentID),
> >> > In each table, there is an Access created ID which is an autonumber.
> >> >
> >> >
> >> > Each table has this StudentID and the ID included. If ID is the primary
> >> > Key,
> >> > I can create a relationship but the link between all the tables is the
> >> > StudentID. I can't create a relationship based on the StudentID.
> >> >
> >> > Thank you in advance for your help.
> >> >
> >> >
> >>
> >>
> >> .
> >>
>
>
> .
>
From: forest8 on 6 Jan 2010 18:48
In my database, I have several tables. I tried to establish a relationship
between 2 tables first -- each has a primary key. When that failed, I tried
another two -- again each had a primary key.

Still the same result -- no matter which tables I use.

"John W. Vinson" wrote:

> On Wed, 6 Jan 2010 11:49:02 -0800, forest8 <forest8(a)discussions.microsoft.com>
> wrote:
>
> >When I try to create a relationship, I seem to be creating an
> >"Indeterminate" relationship. I can't create a one to one or one to many
> >relationship. I get "Intderminate" relationship.
>
> You will get an Indeterminate relationship if you are joining two tables on a
> field, and that field does not have a UNIQUE index in either table.
>
> Ordinarily one would join from the Primary Key of the "one" side table in the
> relationship, to a foreign key in the "many" side table. The Primary Key is by
> definition unique, and Access will create a unique index on it for you.
> Creating a relationship and enforcing referential integrity will automatically
> create a non-unique index on the foreign key field for you.
>
> It sounds like you either haven't established primary keys, or that you're
> trying to join on some other field or fields.
> --
>
> John W. Vinson [MVP]
> .
>
From: Gina Whipp on 6 Jan 2010 19:10
forest8,

Ummm, did you not see the rest of the post? You need to help me out here
and identify Primary Keys and Foreign Keys so we can help you. If there are
more tables then we need those also.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"forest8" <forest8(a)discussions.microsoft.com> wrote in message
news:E3E27F87-7653-4541-8472-0F0A68257A30(a)microsoft.com...
> Hi there
>
> Yes. Those are some of my tables.
>
>
>
> "Gina Whipp" wrote:
>
>> forest8,
>>
>> Help me out... I have listed a few tables based on your description.
>> What
>> am I missing and where/what are the Primary Keys and Foreigh Keys? ith
>> that
>> I can lead you in setting up Relationships.
>>
>> tblStudents
>>
>> tblEnrollment
>>
>> tblCourses
>>
>> tblTeachers
>>
>> tblSurvey
>>
>> tblMeetings
>>
>> --
>> Gina Whipp
>> 2010 Microsoft MVP (Access)
>>
>> "I feel I have been denied critical, need to know, information!" -
>> Tremors
>> II
>>
>> http://www.regina-whipp.com/index_files/TipList.htm
>>
>> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
>> news:C4647781-EF5C-44CA-BEAF-8471CA918025(a)microsoft.com...
>> > Sorry for the lack of information in the initial question. I've been
>> > frustrated by my inability to create relationships.
>> >
>> > When I try to create a relationship, I seem to be creating an
>> > "Indeterminate" relationship. I can't create a one to one or one to
>> > many
>> > relationship. I get "Intderminate" relationship.
>> >
>> > I'm tracking enrolment, grades, adds/drops, etc. There is also a survey
>> > based on how the students have rated their courses/teachers. As well,
>> > there
>> > is a table which tracks the frequency and subject of any meetings
>> > between
>> > student and teachers.
>> >
>> >
>> >
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> forest8,
>> >>
>> >> Going to need to know a wee bit more information. All we know so far
>> >> is
>> >> that you have a Students table, what are the rest of the tables? What
>> >> are
>> >> you tracking, enrollment, attendence, grades...? You say , "I can't
>> >> create
>> >> a relationship based on the StudentID.", but you don't say why you
>> >> fell
>> >> you
>> >> can't do that.
>> >>
>> >> --
>> >> Gina Whipp
>> >> 2010 Microsoft MVP (Access)
>> >>
>> >> "I feel I have been denied critical, need to know, information!" -
>> >> Tremors
>> >> II
>> >>
>> >> http://www.regina-whipp.com/index_files/TipList.htm
>> >>
>> >> "forest8" <forest8(a)discussions.microsoft.com> wrote in message
>> >> news:5207ABC9-1399-414D-9E6D-739A3DD1C05A(a)microsoft.com...
>> >> > Hi there
>> >> >
>> >> > I've searched through the database and have read about
>> >> > Relationships,
>> >> > Primary Keys, and Foreign Keys. But I am still having problems with
>> >> > my
>> >> > database.
>> >> >
>> >> > I currently have a database that has several tables. The primary
>> >> > table
>> >> > is
>> >> > a
>> >> > list of students where their student number is the primary key.
>> >> > (StudentID),
>> >> > In each table, there is an Access created ID which is an autonumber.
>> >> >
>> >> >
>> >> > Each table has this StudentID and the ID included. If ID is the
>> >> > primary
>> >> > Key,
>> >> > I can create a relationship but the link between all the tables is
>> >> > the
>> >> > StudentID. I can't create a relationship based on the StudentID.
>> >> >
>> >> > Thank you in advance for your help.
>> >> >
>> >> >
>> >>
>> >>
>> >> .
>> >>
>>
>>
>> .
>>


From: John W. Vinson on 6 Jan 2010 19:18
On Wed, 6 Jan 2010 15:48:02 -0800, forest8 <forest8(a)discussions.microsoft.com>
wrote:

>In my database, I have several tables. I tried to establish a relationship
>between 2 tables first -- each has a primary key. When that failed, I tried
>another two -- again each had a primary key.
>
>Still the same result -- no matter which tables I use.

Details, details please!

Please post:

Table names
Name of the Primary Key field of each table (and it does show the key icon
next to the fieldname in table design view... right?)
Datatype of the Primary Key (maybe autonumber, maybe some other field type
you've chosen)
Name and datatype of the foreign key field


Note that datatypes and field sizes must match: an Autonumber primary key must
be joined to a Long Integer (non-autonumber!!!) foreign key.

If you would like, you could zip the database and email it to me; I'll be glad
to investigate and see if I can figure out why you can't create relationships.
Send to jvinson <at> wysard of info <dot> com - edit out the blanks and edit
in the punctuation.
--

John W. Vinson [MVP]
From: Gina Whipp on 6 Jan 2010 19:44
John,

I have been trying to get them... Even helped out with one of my posts but
to no avail.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message
news:bs9ak5ds774qf7mml8ekeagvcdenp0a7ps(a)4ax.com...
> On Wed, 6 Jan 2010 15:48:02 -0800, forest8
> <forest8(a)discussions.microsoft.com>
> wrote:
>
>>In my database, I have several tables. I tried to establish a
>>relationship
>>between 2 tables first -- each has a primary key. When that failed, I
>>tried
>>another two -- again each had a primary key.
>>
>>Still the same result -- no matter which tables I use.
>
> Details, details please!
>
> Please post:
>
> Table names
> Name of the Primary Key field of each table (and it does show the key icon
> next to the fieldname in table design view... right?)
> Datatype of the Primary Key (maybe autonumber, maybe some other field type
> you've chosen)
> Name and datatype of the foreign key field
>
>
> Note that datatypes and field sizes must match: an Autonumber primary key
> must
> be joined to a Long Integer (non-autonumber!!!) foreign key.
>
> If you would like, you could zip the database and email it to me; I'll be
> glad
> to investigate and see if I can figure out why you can't create
> relationships.
> Send to jvinson <at> wysard of info <dot> com - edit out the blanks and
> edit
> in the punctuation.
> --
>
> John W. Vinson [MVP]


First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4
Prev: Lists of Commands - stevie is pimping again
Next: "collecting data via email" when recipient uses Hotmail or Yah