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

"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.

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.