From: Gina Whipp on
<smile>

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Keith Wilby" <here(a)there.com> wrote in message
news:4b14d905$1_1(a)glkas0286.greenlnk.net...
> "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message
> news:uSEs8XicKHA.4724(a)TK2MSFTNGP05.phx.gbl...
>>
>> You are looking for a reason to argue and I was simply answering a post.
>>
>>
>
> Don't try to engage in a battle of wits with an un-armed opponent.


From: dsmith via AccessMonster.com on
Thanks guys,
I finally got it working...I appreciate your willingness to help those of us
trying to learn. Access is a great program...hopefully I will learn enough to
share in the future.

Arno R wrote:
>> Firstly, the OP's tables are correctly designed. Why would you recommend he look at a
>> survey database? Secondly, you said "You will need a *joiner* table. Again, the OP's
>> tables are correctly designed. He doesn't need any more tables!!! Your recommendation
>> was completely erroneous and would only serve to confuse the OP further.
>
>Hi $teve, why are you constantly making a fool of yourself ??
>Simply put: Gina is right and you are not... You are acting very childish *again*
>Also: You are simply not understanding the question and/or not reading properly...
>(as usual)
>
>OP asked
>"Should I have an ObserverID fk in tblQuestion since each observer must address all 20 questions with each observation?"
>The answer has been given by Gina..
>"no you shouls not have ObserverID in tblQuestion"
>This is a correct answer while you state that it is wrong...! (only typo there)
>
>The OP tells us: "Supervisors will observe procedures and mark them as "safe" or "at-risk"
>So we need a *joiner* table to collect these observations. Gina is right on this...
>This *joiner* is your proposed TblLocationObservation I guess.
>
>BUT:
>The OP's tables (you mean yours??) are *not* quite right...
>The proposed table TblObservation as such is completely *nonsense*!
>You are storing *what* here?? Date and Observer... Related to what ??
>You are missing Location??
>
>Maybe the ObservationDate from TblObservation easily be stored in the table TblLocationObservation.
>Also things like ObservationTime and such...
>Well to be honest... it depends on whether we need the day-time per procedure that we check....
>But we definitely don't need the tblObservation as you proposed....
>confusing and erroneous indeed....
>
>To the OP:
>==> I would consider each and every answer given by $teve as 'At-Risk'
>==> I would consider each and every answer given by Gina's as "Safe"
>
>Also I would try to give *meaningful* names to the fields.
>That can be very helpful to 'understand' the information we are gathering.
>
>The supposed fieldname 'LocationObservation' does indeed serve to confuse...
>Why not use ProcedureObservation instead ?
>
>Regards, Arno R

--
Message posted via http://www.accessmonster.com