Problems with a checkbox set

[DavidTrap]

I am having problems with a checkbox set.

I have a list of procedures identified by item numbers and descriptors. These are two fields of a table. There are also corresponding unit values for each procedures.

Multiple procedures can be used for one patient - they are selected by a checkbox value list.

I am trying to write an invoice using this data. By using a "merge field" I can get a list of the item numbers, but only the first of the corresponding "descriptions" and "unit values" appear.

Am I going about this completely the wrong way, or can you suggest any solutions. Ultimately I need to multiply the unit value for each selected item by a dollar value per unit and add that up to give a total.

This is my first database, and much has been learnt by trial and error. However, I'm now stuck and need some help...

Thanks

DavidTrap

Cutdown.fp7.zip

[Vaughan]

"Multiple procedures can be used for one patient - they are selected by a checkbox value list."

This would be better of done with related records instead of a checkbox set in a single field.

[DavidTrap]

The multiple procedures refers to the actual checkbox items rather than the overall "procedure" for the patient. I do have related records set up for the eventuality of different procedures on the one day.