Split Layouts from two tables?

[Topher]

First of all, I want to thank everyone on this site. Everyone is so helpful and quick to respond.

So I have a database that keeps track of an exchange program of American and French students, that are exchanged between their home universities.

I'd like a layout (almost like a student directory printout) that has French students on the left and American students on the right, sorted by which American University they're going to and coming from respectively.

It seems impossible because we'd have to create a list layout with different data from two tables.

Is this at all possible? Are there any other ideas/solutions?

Thanks so much!

[bcooney]

Do you have the Students split into two tables? American and French? I would suggest putting them into one table and adding a StudentType field that is a radio button choice, ()American ()French.

You can create a sub-summary report by StudentType for your directory (however, it is difficult to get the left/right columns that you request).

Also, you need a University table and a join table btw Students and University; "Enrollment".