Combo box to select an entry, then add notes for this entry (multiple times)?

[fraser_lindsay]

Hello,

I have a form based on a query. This form has a tab called 'Restrictions'.

On this tab I can select a type of restriction from a combo.

Under this I have a box for free text so the user can add notes relevant to this restriction.

I have just realised that the user may want to add more than one restriction, each with notes attached.

How do I do this, while keeping all of the info displayed on the form for someone browsing it? i.e. listing all retsrictions and their associated notes.

Is it a subform?

Any help would be greatly appreciated.

 

[statsman]

There are a number of ways you could go about this. My preferred method would be the simplest.
What is the maximum number of restrictions an individual may have. If it is five or less, simply add four additional restriction codes and notes to the table.
Example:
Change your current restriction code and restriction notes to
Restriction1 and
RestrictionNotes1

Then add Restriction2 and RestrictionNotes2 and continue until you have all of the restrictions and notes you need.

Then place the additional restrictions and notes into the tab on your form.
You will have to adjust the query to accept the additional fields.

 

[GaryPanic]

ddo you need to anylise the restrictions in any way or are they just notes

if they are just notes then you can append the type /notes into a memo feild (but you cannot anylise this) .. then you would ahve a memo field that would list info something like


Restriction type A

notes "bvdfgdgkdfkgdfgjkdlfgkldjflgkjdklcfdfgdfgdfgdfgdfgdfgdfgdfgdfgdfgdfgergergerreerterterter"


Restriction type A

Notes
kjjghjgkkdopepelw,wmdfilds,smnfwc,ewc weclmcwmfewmfwmpemppmwfpmwefwepfewepoewfwoepf pwpepwpwepewp

 

[DCrake]

That's fine if you only have one or two but any more you are going to have difficulty analysing it later. What you could do is to add a new table which will hold 4 fields

Field 1: Parent Primary Key
Field 2: Restriction number - Sequential counter
Field 3: Restriction code/Description
Field 4: Notes

then create a relationship between the parent record and the restrictions table as a one to many.

Then on you form you will need a nested sub form to handle many restrictions.

David

 

[fraser_lindsay]

Thanks you all for your replies, I'll think about these options and see what fits best.

There wouldn't be any more than five per employee, generally there's none, but I need the ability to add a few at least.

I would run a report and/or filter on the restriction category, but there's not much I can do with the notes field. It will be populated by patient specific notes by a doctor and/or nurse. At best I would simply look to lift this text on to the report.

Thanks

 

[DCrake]

As you suggest you will want to analyse the number of restrictions by patient or by period. By having multiple fields in one file would involve the use of union queries. If you arre happy with them then that ok. however by having them in a seperate table will give you the flexibility you require. Remember, fields can be expensive but rows are relatively free.

David