I am creating a billing database. I created a relational db between the billing db and an anesthesia procedures db. In the anesthesia procedures db there is a procedure field, that procedure's coding number in a field, and the procedure's cost in a field. I have created a checkbox in the billing database from this related "anesthesia procedures" database. When a provider does a case, he would check the procedures he completed for a case. There could be more than one procedure, or no procedures if it is a routine case not requiring special monitors. I chose a check box so multiple choices could be made in the field.

My problem is to create a calculation field (total procedure charge) which sums all of the boxes checked in the check box using the associated procedure cost from the anesthesia procedure Database. So far, it will only place one charge from the choices checked in the check box, even though 2 or more are chosen and I cant figure how to get FM to add several procedure charges together.

Any Ideas.

If it would be better to post this question to a different forum, please advise.

Thanks.

[ June 12, 2001: Message edited by: vyoung ]

[ June 12, 2001: Message edited by: vyoung ]

I figured it out, I had placed the wrong layout field in the procedure charge (::charge) from the anesthesia procedure portal, instead of the Total procedure charge from the billing database, with the defined field calculation of Sum(Anesthesia procedure::charge).