AnsweredAssumed Answered

Duplicating a record with portal information

Question asked by SKY on Feb 13, 2012
Latest reply on Feb 15, 2012 by SKY


Duplicating a record with portal information


I know that this has been posted before, especially here:

and here:

I tried to adapt the scripts to do a the same for my database.  I've been working on it for a few days now and can't get it to work.  I was hoping that someone on here might be able to help?  The part of my database that I need help with is the encounter.  When a patient returns, I would like to not have to punch in all the same diagnosis codes (ICD_9_ID).  For each encounter, there are ICD_9_IDs and CPT_IDs.  Often times the CPT codes change, so I'm not interested in duplicating these.  I would just like the new encounter to copy all the ICD_9_IDs over to the new encounter.  The encounter table is related to the ICD9 and CPT code tables via a join table.


My encounter table is set to automatically create and delete records from the join table, so I don't have foreign and primary keys (I'm currently thinking this is my main problem trying to accomplish my goal).  I followed the links above, but am still having problems.  I assume that my join table is like the line items table from that script and that my ICD_9_ID is similar to the partsid, but haven't been able to get it to work.

Any experienced FM users willing to help me out a little?  I'd really appreciate it!




case join