On Fri, 7 Mar 2008 07:14:25 -0800 (PST), Ron2006 wrote:

Reason is simple.

I has NO idea what course ID to use since it is not a child of
anything when you open the form independently.

If sites is really independent of courses and/or School, then it
should be a separate table of JUST sites and what you select in form 2
should be a table that contains the courseID and the selected Site id.

If site is entirely dependent on course then it should never be
created except in a situation where the system can know what course is
involved.

Ron

I'm completely lost here, Ron.

Are you asking me to explain your requirements specs to you?

I have no idea even what a Site is; how a course is related to a site, etc.

You say IT is no help (well, that's not unusual :-{( ), but you have not -
that I have seen anyway - posted a human-readable description of the problem
that you are trying to solve. Let's step back a bit - what will people out in
the real world actually DO with this database?
--
John W. Vinson [MVP]