Help with 2 tables

[tracy.cooperjr]

Hello. I am working on a database for my college. I have 2 tables. I
believe I may need to combine them into a third. My first question is
do I need to. My next is if I do then how can I do that and if I don't
then what do I need to do.

The first table contains the students accommodations. It contains

ID L#
AccommodationType Comment
Autonumber Text(StudentID) ComboBox(Pulled from a
different table) Memo
Table 2 contains the students class schedule. It contains the StudentID
and Class.

I need to create a table or something else which will allow for the
following.

When the counselor pulls up the students class they should be able to
choose which accommodation they want the student to have per class. The
counselor should only be able to choose from the students
accommodations listed in table 1 not from the list of all
accommodations possible that the AccommodationType pulls from. If you
have any questions contact me ASAP.

[pietlinden]

tr************@gmail.com wrote:
Accommodations(AccommodationID, Type, Comment)
Schedule(StudentID, ClassID)

>
The first table contains the students accommodations. It contains

ID L#
AccommodationType Comment
Autonumber Text(StudentID) ComboBox(Pulled from a
different table) Memo
Table 2 contains the students class schedule. It contains the StudentID
and Class.

I need to create a table or something else which will allow for the
following.

When the counselor pulls up the students class they should be able to
choose which accommodation they want the student to have per class. The
counselor should only be able to choose from the students
accommodations listed in table 1 not from the list of all
accommodations possible that the AccommodationType pulls from. If you
have any questions contact me ASAP.

This description is almost completely meaningless. Stick to business
rules. The rest is not very helpful. What do you mean about
accommodation? What does it mean in your case? I'm not going to find
a dictionary to look it up, but... so explain it if you would.

A student has a schedule and for each class he needs an accommodation,
and they're listed in another table? or are only some accommodations
relevant to some classes? From your post, it's hard to tell. could
you explain further?