Duplicating a record with portal information
I know that this has been posted before, especially 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!