By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,025 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,025 IT Pros & Developers. It's quick & easy.

Help with 2 tables

P: n/a
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.

Dec 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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?

Dec 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.