Hopefully, this is an easy question!

[scherico]

I am working on a database for a Medical Practice. I have 10 fields for procedure code names. Procedure1, Procedure2, etc. I then have 10 code fields, code1, code2, etc. They are set up across from each other.

 

All I want to do, is if code 37799 is put in the code1 field, I would like "Carotid Stent" to pop up in procedure1. If code2 is 37215, I would like Transcath plcmt to populate field procedure2, etc.

 

I know this is simple, but I am drawing a complete blank!Opps!

[AHunter3]

I am working on a database for a Medical Practice. I have 10 fields for procedure code names. Procedure1, Procedure2, etc. I then have 10 code fields, code1, code2, etc. They are set up across from each other.

 

Ahem

 

(I agree, by the way).

 

You should have one and only one Procedure field. One and only one Code field.

 

You need a related table to put those in if your local record has more than one of each.

[touchMe]

stop thinking spread-sheets, and think FileMakersmiley-smile

[scherico]

I agree. Stop thinking spreadsheet! Still, I have to list more than one procedure code, so for a quick fix, I created the 10 fields. I also need to sort them all, etc. I know it's not the easiest way, but it works for what I need it too.

 

Thanks for the help. I always get great responses from this forum.smiley-laughing

[Doug@URG]

I see you have ten procedures and the codes along the side of each one. When you type in the code you want the procedure name to appear in the procedure column along side of it. I would use the "Case" function for each of the procedure fields. For procedure#1 I would define the field as a calculation which read: Case(Code#1="37799";"Carotid Stent";Code#1= "37215"; "Transcath plcmt";Code#1="33333";"ProcedureName")

You can keep going using this syntax to have procedure#1 field generate the procedure name when you enter the code into the Code#1 field.

Then copy the function to use on Procedure#2 field Calculation and change the "Code#1" to "Code#2"

There proably are better ways to do it, like making a key with fields and referring to those fields to generate the procedure names.

Hope that may help

Doug@URG