Counter Service Billing

[foxtet]

In the database to manage clinic opd in which I have created 3 tables tblService, tblServiceCat and tblServcieDetail.
I wanted to design a form with embedded subform to selected services obtained by the patient.
I want service subform to be like.
Service name Qty Unit price Total Price
x-ray chest 1 2.00 2.00
x-ray knee 3 5.00 15.00
total: 17.00
Extra charge 34.00 (for expatriate total *2)
Grand Total: 51.00
Covered by insurance 51.00
Amount paid 0.00

[FONT=&quot]How it is possible to design as the above? [/FONT]

 

[JHB]

When I look at the attached document, I can not see how you get the values ​​that you do.
Ex.
X-ray knee: how do you get Qty=3 and a price of 5 per unit?
How does the it related to each other?

 

[foxtet]

the access file is attached. i find it difficult to make a query to obtain services that customer is provided.

foxtet

 

[JHB]

the access file is attached. i find it difficult to make a query to obtain services that customer is provided.

foxtet

Sorry but I can't still find out how the data is related to each other, can you from the data you provided show which result you want to get?
How/where is the customer identified in the data?

 

[foxtet]

I also find it difficult to relate tables to get out put.

Foxtet