Populate Day and allowable times based on date picker

[jzwp11]

So you will just have a table that lists the possible ACT Composite scores and tie a particular one to the student? If so, then it would work, but to keep it simple, you could just have the user enter the actual score, right?

I thought that you might be breaking out the ACT scores by subject area. That would be a one-to-many relationship.

[nchesebro]

The composite, math, english, writing, and science scores will all be listed.

[jzwp11]

Then you have a one-to-many relationship, so it cannot be included in tblPeople but rather in a related table. You will probably save yourself some time by having a separate table to hold the subject areas/composite names and then junction that. I'll let you give the structute a shot.

[nchesebro]

tblACTTest
-pkACTTest
-txtTestType

tblACTScore
-pkACTScore
-longACTScore

tblACTTestScore
-pkACTTestScore
-fkACTTest
-fkACTScore

tblPeople
-bla
-bla
-bla
-fkACTTestScore

How did I do?

[weekend00]

How can you guys discuss one topic so much and for so long time?

[nchesebro]

Its a project i have to do for work... I figured it would be simple untill the question was asked "Is your database normalized?" and I was like, What the heck is that?.... and we have been rolling along ever since. I am getting close to the end result, I think...

[weekend00]

good luck!

[jzwp11]

tblACTTest
-pkACTTest
-txtTestType

tblACTScore
-pkACTScore
-longACTScore

tblACTTestScore
-pkACTTestScore
-fkACTTest
-fkACTScore

tblPeople
-bla
-bla
-bla
-fkACTTestScore

How did I do?

This will allow you to only assign 1 test score to a person not many. Hint: junction table.

[nchesebro]

tblACTTest
-pkACTTest
-txtTestType

tblACTScore
-pkACTScore
-longACTScore

tblACTTestScore
-pkACTTestScore
-fkACTTest
-fkACTScore

tblPeopleATCTestScore
-pkPeopleACTTestScore
-fkACTTestScore

tblPeople
-bla
-bla
-bla
-fkPeopleACTTestScore

Is this it?

[jzwp11]

Not quite...

tblPeopleATCTestScore
-pkPeopleACTTestScore
-fkACTTestScore
-fkPeopleID

tblPeople
-bla
-bla
-bla
-fkPeopleACTTestScore (remove)

[nchesebro]

Ok...

I think i have all my tables in order, and proper relationships in place. I think i am FINALLY done with this table business.

But before I say that 100%, i need my eyes. If you wouldn't mind, take a look at the tour database I have attached to verify my claim. If it is all set, i think thats the go ahead to possibly.... maybe... start working on a form?

[jzwp11]

You did not modify tblPeople in order to link with the zip code table, so I took care of that in the attached DB. Also, you still need to join tblEntryTerms, tblMeritAwards and tblStatus to tblPeople (I assume). I think you can get rid of tblStProv since you have the zip code table now, correct?

After all of the tables/relationships are set up, then it is time to work on the forms.

[nchesebro]

I just got done rearranging the relationships view, and did find some scragglers as you pointed out: tblEntryTerms, tblMeritAwards, tblStatus.

First, thank you for making that conneciton, it completely slipped my mind

Second, I would guess that they would be joined to tblPeople since these are attributes associated with the person.

Yes, I think it would in fact be appropriate to delete tblStProv.

I have made those relationships, take a look at what i have attached. I think it is all set, unless, when you scroll down to the bottom, there are some smaller groups, i think they are supposed to be linked to either tblTour or tblPeople...

[jzwp11]

It looks good. The date table was to include athletic events and black out dates, you might link it to the ticket table. You can always remove the join if issues develop, so it is not that big of a deal. You'll have a better idea once you get your forms set up & do your testing.

[nchesebro]

To begin the form, would i just open a blank form and start placing objects on it, and then edit the control source later on?