Re: Getting Two Existing Tables to Relate in a Form.

Table1
StudentNumber
FirstName
LastName
SS#
etc.

Table2
ClassNumber
ClassName
etc.


Table3
StudentNumber
ClassNumber
DateCompleted
ClassGrade





--
Rick B



"SkyGuy" <SkyGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:279A470C-7A2B-4890-A62E-FAC52485E8D9@xxxxxxxxxxxxxxxx
> No Rick I do not have a third table. I'm wondering if creating an
> AutoNumber
> in each of the two tables then making it the Primary Key for them to link
> on.
> Sounds too simple though and I'm new to this...
>
> "Rick B" wrote:
>
>> Do you have a third table where you specify which classes each student
>> has
>> taken? This is a Many-to-Many relationship and it requires at least
>> three
>> tables.
>>
>>
>>
>> --
>> Rick B
>>
>>
>>
>> "SkyGuy" <SkyGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:0D5BD746-1A93-4F0D-86C4-9F0C215CE56B@xxxxxxxxxxxxxxxx
>> >I have a form that displays records from two tables. The first table is
>> >named
>> > Students. The second table is named Classes.
>> >
>> > At the top of the form the Student table information displays. At the
>> > bottom
>> > of the form the classes the student has taken should display. However,
>> > when I
>> > go to the next student in the form the classes do not change at the
>> > bottom.
>> >
>> > There's no common key between the two tables so I know that's the
>> > problem.
>> > But since these tables (which have many records) and form already exist
>> > how
>> > do I solve this problem?
>> >
>> > Thank you in advance!
>>
>>
>>


.

Relevant Pages

  • Re: Getting Two Existing Tables to Relate in a Form.
    ... > No Rick I do not have a third table. ... > in each of the two tables then making it the Primary Key for them to link ... >>> At the top of the form the Student table information displays. ... >>> bottom ...
    (microsoft.public.access.gettingstarted)
  • Re: too long a formula, can someone cut it down
    ... I don't see how that can be as the formula I posted produces the same results as the one Gary''s Student posted. ... Rick ... >> its text into the subtotal row 70. ... I need to get A70 up to ...
    (microsoft.public.excel.programming)
  • Re: OnKey problem
    ... Thanks, Rick! ... Rick (MVP - Excel) ... is there a way to trap specific keystokes in a textbox? ... Gary''s Student - gsnu200827 ...
    (microsoft.public.excel.programming)
  • Re: How do I create this form?
    ... > Rick, thanks, but I did try the template and it does not do what I want. ... >>> then another combo box to pull up an assignment and then enter the ... >>> I have the recursive table because one student will have many ...
    (microsoft.public.access.forms)
  • Re: In form view, my form is blank.
    ... I entered some records into the student table, but noting in showing up in ... "Rick B" wrote: ... Go run the query and make sure records appear. ... >> I'm trying to set up a database with student information (last name, ...
    (microsoft.public.access.gettingstarted)
Loading