Mutli value field? - Memo field?

[Guest]

Hi

A little help please.

I'm developing an application which is intended to make a record of the
perfromance of an employee against set criteria. There are around 20 criteria
to be measured by the person monitoring the employee's activity.

The user wants a single field into which the criteria heading can be entered
in the event it failed .... and into which can be entered more than one
criteria heading for any given monitored activity.

So, for example, I end up with a record like this

Date : "today"
Time : "now"
Employee : "a.n.other"
MeasuresFailed: "number1", "number2", "number6"

I guess I need a memo field for MeasuresFailed, but where it gets difficult,
is the user has defined that the input form to be used by the person
monitoring should have a list box representing MeasureFailed from which can
be chosen each of the items failed (i.e. multi-selection). Can a
multi-selection list box be used to populate a string of text into a memo
field? (with, perhaps, a comma or even a line feed to separate each)

Any help (even if its "no you can't do that") would be appreciated.

Thanks

Michael Bond

 

[Rick Brandt]

Hi

A little help please.

I'm developing an application which is intended to make a record of
the perfromance of an employee against set criteria. There are around
20 criteria to be measured by the person monitoring the employee's
activity.

The user wants a single field into which the criteria heading can be
entered in the event it failed .... and into which can be entered
more than one criteria heading for any given monitored activity.

So, for example, I end up with a record like this

Date : "today"
Time : "now"
Employee : "a.n.other"
MeasuresFailed: "number1", "number2", "number6"

I guess I need a memo field for MeasuresFailed, but where it gets
difficult, is the user has defined that the input form to be used by
the person monitoring should have a list box representing
MeasureFailed from which can be chosen each of the items failed (i.e.
multi-selection). Can a multi-selection list box be used to populate
a string of text into a memo field? (with, perhaps, a comma or even a
line feed to separate each)

Any help (even if its "no you can't do that") would be appreciated.

You need TWO tables. Each Employee can have zero, one, or many
MeasuresFailed. That is a one-to-many relationship and needs to be modeled
with two tables having a one-to-many relationship defined between them.
Then you use a form/subform combination to enter each of the possible
MeasuredFailed into its own record that is a child record of the Employee
record in the parent form.

 

[Guest]

Thanks Rick

The proposed solution works perfectly, although I need to use a combo box
rather than a list box in the sub form for each record. It meets my user's
needs and that is all important.

Regards

Michael Bond