creating a user input form based on many to many relationship

[Guest]

Hi All:
I have been working this problem for over a week. All the examples thus far have failed to help. I have a mental block and need your help.

I want to create a user input form where the user selects an analysis activity from a drop down list. This will cause a subform to open with one or more attributes applicable to that analysis activity. Along with a rating text box beside each attribute where the user will enter the rating. Here are the tables and fields (first row beneath the table name is the key field, except the join table where the key fields are both AnalyDataID and AttribID).

tblAnalyActivity tblAnalyAttrib tblAnalyData tblJoinAnalyAttribandData
AnalyActID AttribID AnalyDataID AnalyDataID
AnalyActDescription AnalyActID AnalyActID AttribID
AttributeDescription Date Rating
PerfBy

All my queries and forms have been unsuccessful to date. I really need your help.

Thanks

 

[Mary]

Your question is not easy to understand, and you may
therefore find that it does not attract an answer.
However, do look at it as it appears here and understand
why it is difficult to understand then post it again.

Sometimes respondents in this group are scathing or non-
responsive when this happens. They rail against those who
post (unkowingly?) in the wrong thread. That is to their
discredit - they fail to remember that one day they too
found these newsgroups for the first time and were
struggling to leap the next hurdle in their
access/excel/vba learning.

Most of the people you will encounter here genuinely want
to help. Some of them are absolute genuises in their
fields. If you spend an hour of your time accurately
defining the question they are better able to give you a
clear cut answer in the few minutes they may have to spare.

I am not one of the genuises.

Mary

-----Original Message-----
Hi All:
I have been working this problem for over a week. All

the examples thus far have failed to help. I have a
mental block and need your help.

I want to create a user input form where the user selects

an analysis activity from a drop down list. This will
cause a subform to open with one or more attributes
applicable to that analysis activity. Along with a rating
text box beside each attribute where the user will enter
the rating. Here are the tables and fields (first row
beneath the table name is the key field, except the join
table where the key fields are both AnalyDataID and
AttribID).

tblAnalyActivity tblAnalyAttrib

tblAnalyData tblJoinAnalyAttribandData

AnalyActID

AttribID AnalyDataID AnalyDataID

AnalyActDescription AnalyActID AnalyActID AttribID

AttributeDescription Date Rating

PerfBy

All my queries and forms have been unsuccessful to

date. I really need your help.