adding records from either join file

[nati]

I have a course db, a session db, line item db, and a student database. I add the students to the course through a portal in the session db. Is there a way I can also go to the student db, find the student and add them to a course from the student db file?

Many thanks,

nati

[Kurt Knippel]

quote:

---

Originally posted by nati:

I have a course db, a session db, line item db, and a student database. I add the students to the course through a portal in the session db. Is there a way I can also go to the student db, find the student and add them to a course from the student db file?

Many thanks,

nati

---

You are already doing all the work. You add the student to the course via a record in the sessionDB. Just add a course to the student though the sessionDB. It is the same exact procedure, you are just picking the other value.

[nati]

Thanks, captain. So, the student db does not have a relationship setup. The session db gets the student through a lookup. Do I add a relationship to the line item file like I do through the session db, including the create new records?

Thanks,

nati