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

You are losing me.

You have a list of people in one table.

You have a list of available classes in another table.

Now, you need a new table to tell it which people took which class. John
might have taken PSYC2301 in Fall of 2005 and ENG1301 in Spring of 2005.
Phil might have taken PSYCH23020 in Fall of 2005 and ENGL1301 and MATH1301
in Spring of 2005. Etc.

You have to have a third table in this case, unless your structure is flawed
in some way.

--
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: 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)
  • Re: How many iterations it takes to get to 0?
    ... OK, Rick, let's take this a step at a time: ... and as you can see 4 iterations got use below 50. ... Gary''s Student - gsnu200720 ... If you decrease it 20 % of its original value it will take 5 ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Password Entry
    ... time whether we like it or not when reviewing a student in our class. ... "Rick B" wrote: ... What prevents your user from opening the table ... > directly and making changes? ...
    (microsoft.public.access.forms)