table problem with combo box values

[Mi]

Hello,
I am having headaches over this one. I am creating a review database. Table A contains the general information such as employee, review date, project name, review type with a lookup to Table B. Table B contains the review types, (there are 95 in all as of 5 minutes ago). Each review type needs to have a specific value allowed to be selected or entered (such as y/n drop down or $amount or Date. I would like to use the tables to create a Main form with subform. This will allow the general info only entered once, then select in the subform the review types and then "score" each review with the appropriate value.

Employee ReviewDate ProjectName ReviewType Score Value Score
joe 2/1/05 Apple Corr Y/N Y
joe 2/1/05 Apple Value $ Amount $1500
joe 2/1/05 Apple Contact Date 1/15/05


Any help would be appreciated.
Mi

 

[Mi]

table with subform problem?

Revised this one.
Table A has general info such as employee, review date, review type and score. The Review Type and Score are lookups from Table B and Table C.

Problem 1. I have been unable to get the right combination to prevent duplicates. Same employee, same review date, different review types
Example:
Joe, 1/15/05, Corespondence , Yes
Joe, 1/15/05, Complete , No

Problem 2.
Would like to use a form with a subform due to the general information.
Main form will collect the general infomation and subform with combo box to select review and score. I have been unable to get both the review and score to show in the same subform.


Thanks a bunch!
Mi