Re: Mutli value field? - Memo field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

mabond wrote:
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.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Extract Records via Userform
    ... The criteria range can have multiple rows and deliver some strange combinations of data. ... The employee has transferred ... charged while he has been working for his current supervisor that the ...
    (microsoft.public.excel.programming)
  • Re: Report parameters
    ... It looks to me like you should add some option boxes on to you criteria ... selection form with the options All, Range, Single. ... I have a button called cmdfilter, two option boxes - 1 called optDateRange ... > PK from the Employee table); ...
    (microsoft.public.access.reports)
  • Re: Not like
    ... The field is text and is used to store notations or employee status and ... number and if not scheduled it will have the word Off and that criteria work ... for that field to exclude the employee Off or not scheduled. ...
    (microsoft.public.access.queries)
  • Re: Subscript Out of Range Error
    ... "JLGWhiz" wrote: ... an area that he, at some point, decides he wants to add new criteria to ... it to the list in the QA Template and each employee workbook so that all ... that will be mirrored in all employee workbooks and the QA ...
    (microsoft.public.excel.programming)
  • RE: Internet E-mail monitoring/approval
    ... At our organization we had a recent "Witch Hunt" where a HR employee started ... By "SCOPE" you have to define ... monitoring policies and investigation policies. ... This message is a PRIVILEGED AND CONFIDENTIAL communication, ...
    (Security-Basics)