I have three databases:

- Users - containing all student information, including the subjects they take in 6 separate fields, which are chosen from a value list (group 1 value list shows group 1 subjects, etc).

- Calendar - containing upcoming deadlines. The "subject" field for each deadline is chosen from a master value list (which contains every single subject from the value lists 1-6).

- Default - where the login page layout is, and where students should be able to see their upcoming deadlines according to the subjects they've chosen.

I want it to look something like this:

I'm really unsure of how to go about it so any input would be greatly appreciated.

Thank you in advance,

Natalia.

So basically I want to get the deadline title to show up in the 'showdeadline' field, if the subject shown in the associated group subject is equal to the subject chosen from the master value list.

If that makes any sense at all...