novoiceleft
Registered User.
- Local time
- Today, 11:41
- Joined
- Jul 4, 2004
- Messages
- 65
Hello All. Please can anyone help me build the following simple thing. I am stuck!! <<NON-TECHIE ALERT MODE>>
I'm actually not sure whether my problem is with the forms - or a query or the tables.
I have one table called Employees – with all the details of each employee. The primary index field is EmployeeID
Each employee is to be given a set of scores against a list of parameters. The list of parameters is in another table called Parameters
ParameterID
ParameterName
What I want to achieve physically, is a form with all the details of the employee on it (ALREADY DONE), with a sub-form on which will appear the list of all the current parameters - with a box to enter a score out of 10 for each parameter … Given that the number of parameters might change, I want the sub-form to reflect the current list of parameters whether the scores have been given or not. Every time a new employee is created, the sub-form will automatically show ALL the current parameters, with any scores that have been entered and blank scores if they have not yet been entered.
I have been trying to get this working using a join table called EmployeeParameterScores. I’m not sure that is the right way.
What I am confused about is how to build my join table with the right relationships – so that the sub-form will automatically load up the list of current parameters with completed or blank scores. OR should my form be based on a Query. I have tried the Query approach, but it won’t let me enter scores (presumably because I have the wrong joins.)
Aaargh. All help appreciated.
NoVoiceLeft
I'm actually not sure whether my problem is with the forms - or a query or the tables.
I have one table called Employees – with all the details of each employee. The primary index field is EmployeeID
Each employee is to be given a set of scores against a list of parameters. The list of parameters is in another table called Parameters
ParameterID
ParameterName
What I want to achieve physically, is a form with all the details of the employee on it (ALREADY DONE), with a sub-form on which will appear the list of all the current parameters - with a box to enter a score out of 10 for each parameter … Given that the number of parameters might change, I want the sub-form to reflect the current list of parameters whether the scores have been given or not. Every time a new employee is created, the sub-form will automatically show ALL the current parameters, with any scores that have been entered and blank scores if they have not yet been entered.
I have been trying to get this working using a join table called EmployeeParameterScores. I’m not sure that is the right way.
What I am confused about is how to build my join table with the right relationships – so that the sub-form will automatically load up the list of current parameters with completed or blank scores. OR should my form be based on a Query. I have tried the Query approach, but it won’t let me enter scores (presumably because I have the wrong joins.)
Aaargh. All help appreciated.
NoVoiceLeft