Concatenate 2 fields into one text box

[zack]

Being fairly new to Access 2000, I would be grateful for any help you
could give. I appreciate there are many other postings for Concatenate
questions, but none seems to help me.

I have 2 tables, Campuses and Courses.
A course may run at one or more campuses.
I have a form based on a query which displays the info of one course at
a time dependant on the course number typed in a parameter box.

A text box on this form displays the campus the course is run at.
There are 2 problems:
1) How do I store in the Course table that a course might run at
multiple campuses?
2)If a course runs at more than one campus, how can I get the name of
each campus to be displayed in one text box?
eg: If one course runs at 3 sites/campuses.
'Campus' New York,Paris,Amsterdam

I would really appreciate help with this, I don't have much more hair
to tear out.
Regards
Zack

 

[Guest]

You need three tables - Campus, Courses, and a junction table.
These would be set up in a one-to-many relation Campus to junction & Course
to junction.
Use a subform in datasheet to display the multiple items.