AnsweredAssumed Answered

Oh... where to begin

Question asked by Magneato on Jul 8, 2009
Latest reply on Jul 13, 2009 by Magneato

Title

Oh... where to begin

Post

My problem is a bit large to be answered all at once, so I really just need to know what direction to head in here...

 

I am using 2 tables in this instance.  One table is a database containing referring doctors contact information(RefDr).  Each record from 'RefDr' contains a field with their license# (lic1).  The other table is a db containing patient info (PtInfo).  Each record from 'PtInfo' contains a field with the referring dr's license# (lic1) and a field for each part of the body to be scanned(scan1, scan2, ...)  What I'd like to do is create a field in 'RefDr' that gives a running total of all the body parts scanned from records in the 'PtInfo' table.

 

EXP/ Dr. Poopypants has a license# of 1122334455.  Everytime that license# appears in a record from 'PtInfo' I would like the sum of the body parts scanned from that and everyother record containing the same license# to be added to a running total summary field in the table 'RefDr'.

 

I have no idea how to write a script but am willing to learn if thats the route I need to go.  Any and all guidance will be appreciated

Outcomes