Re: Still Struggling...

Finally, I decided to create some relationships. I could
never get the ones I needed before. Guess what? It worked....it worked...it
worked! I cried.

Hey, there's no crying in baseball or relational database design ;- )

Again, we aren't on the same page. It's more closely related to Subject
(which is in tblSiteEmps). It's like us asking them, "So, what's your
specialty?". If you have a Sp. Ed. credential, you have gone through teacher
training *plus* additional years training for Sp. Ed.

OK, I guess I'm missing something here. Hopefully you can find a way to make
it
work the way you need. If not, you can post back if you want and we can give
it
another shot.

I tried making a form. I
was able to do it. I tried making a subform for tblSiteEmps but had trouble
linking it to tblEmps. I worked from *before* sunrise to well after sunset. I
had all of my posts, book and other materials. I kept moving between the
newsgroup and my db to find answers to my problems. After working for what
seemed like hours I was finally able to link the two. When I clicked on the
arrow they moved in tandem. :-)

Actually, since this is a 1:1 relationship, you can use a subform if you want,
but it's
not really necessary. You could do it all on one form if you wanted (there's
that damn
monkey wrench again <g>).

Now that you're ready to try creating some forms, the fun is really gonna
start :- )

--
________________________

Sean Bailey
s b a i l e y 2 8 4 AT e c e n t r a l DOT c o m

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200807/1

.

Loading