I've attached a file: Doctor_test.fp7 log/pass: admin/admin

It's a really basic medical practice managment system I'm building for practice.

Could someone tell me how I can make the summary field automatically update ?

(it's the total field on the Visits (receips) layout )

If you have any comments about the database/relationships/structure/GUI, PLEASE do share !

I'm really new at this stuff and I need advice from the masters!

Also, could someone tell me why the value lists on the Visits (receipts) layout do not work

if I'm hosting the file with Filemaker Server 7 ??

(the trial version).

thanks,

Steven

Doctor_test.fp7.zip

Create a calculation field in Visits of Sum(Visit_CPT_codes::Price) and use this instead of your related summary field.

I don't see any problem with the value list.