I'm stumped. I run a not for profit dance school and have been using ebase to keep track of my students and their classes and payments. I have approximately 200 students who can take between 1 and 3 classes out of the 40 classes available. My students are, of course in the "names" file and I have created a separate file called "class info" which lists the class number, grade, instructor, class fees etc. I have created relationships between the two files which work well. (I have created class numbers which relate the two files.) Each class can enter any of about 60 competitions. So I have created another file called "competitions" which is related to the class info file. The relationship pulls info such as entry fees and dates from the competitions file and is displayed in the class info layout. So far so good. Now, however, I need to send out invoices (from the names file, I believe) to each of the students to say how much they owe for competition fees. What I can't seem to figure out is how to display the same class info::competitions relationship in my names file. What relationship should I be building in order to relate all three files? Or can I simply make a window in the names file which would display the relationship which is already resident in the class info file? I'm sure this should be simple but I seem to be hitting a wall here, and can't see the answer. Thanks for any help you can offer. -- Sandy Sereda, BFA Arts Manager Edmonton, Alberta, Canada Email: [EMAIL PROTECTED]
