Look Up

[Dr Alok Modi MD]

Hi Guys, hi terry, hi marc,

I am back.
I have a query though. i have to design a database for a radiology center, where I put in the type of study done like X ray, barium, Sonography, Doppler etc with their subtypes as a cascading look up. That is easy, now I have a list of predifined charges for each of these studies and their subtypes. my problem is that when the user slects , lets say, barium and then subselects, upper abdomen, how do i tell the charge field to select only the amount for barium upper abdomen. What kind of a look up do i apply here which is dependent on the eaxact value in the test field which is a cascading look up field.

Dr Alok Modi MD

[mronck]

RE: Look Up

Hi Alok,

Nice to have you back !

Well, as I see it this is a typical case for handling field rules.
Select the table, go to fieldrules and select the field in which you want select the item.
You can then create a lookup that not only does fill the name field of the product, but also fills the price field and all other fields you would like.
I think you should think over the possibility to get these values and prices in a separate table, so your user can add, change or delete the items. Then you can easely create a lookup from let us say an invoice table to this table.

Hoping to have helped you,

Greetings,

Marcel

[Tom Henkel]

RE: Look Up

Do you have a lookup table for the exact charges? If so, once you know which major and minor category you are using, just combine them to lookup to the charges table.

Tom

[Dr Alok Modi MD]

RE: Look Up

Hi guys thanks for the quick reply. My problem is not solved though. I am aware of look up field rules and in this database I am using two look up field rules, cascading and table look up. Let me elaborate the database in detail here.

when a patient comes to the radiology center, his ID is entered and incremented automatically. His name is entered, OK ? Now I am using table lookup to enter his referral doctor's name and hospital's name. I am using cascading field rule to enter the type of test the doctor has ordered, lets say he goes for XRay. Now XRay can be of chest, abdomen, again it can be front of chest, side of chest, so the rule is X ray, + chest, ++ PA view, ++ lateral view, etc. OK?

Now below this is field, where I have to mention the charge incurred for this particular test, So when the receptionist selects, X Ray, then she will select chest, then PA view, so the radiologist wants me to design it in such a way, that the moment PA view is selected , the relevant charge is automatically enetered in the charge field, as charges will be different for P View, Lateral view etc. Also, there are some 50 types of tests these guys are doing, so even if I design such a table with type of test and the charges in two columns, how do i tell A5, to pick up "X" amount for AP view, "Y" amount for lateral view, Z amount for sonography of the upper abdomen and "A" amount for sonography, lower abdomen.

It is not possible with a table lookup because then I get a list popping up with the test on the left side and the charge in the second column. He wants it so that the moment test A and subtype A is selected the predecided charge gets filled up in the charge field automatically and his secretary does not have to select from long list of tests and charges. Again a table look up doesn't work here because the type of test are entered in the previous field as a cascading field rule.
You get my problem? I am also not sure if the "IF" function or the "Lookup "function can help me here.

Can u help me please ?

[Tom Henkel]

RE: Look Up

A table lookup is EXACTLY what you need to do. Your Cost table must have a record for each instance. The key would be all of the views, and the dollar amount would be specific for each view.

ie
xraychestlateral 250.00
xraychestpaview 145.00
etc.

This way, after the last subtype is entered, the key is built, and it is a matter of going to this new table and retrieving the cost.

Building this lookup table will be tedious, but not difficult. just be sure that every different type of view is entered.

Tom

[martinwcole]

RE: Look Up

I am waiting for budget approval from a chain of hospitals for two apps - radiology/courier and respitory.

Although currently the Respitory Care will be the most complex program from the hospital's standpoint, it could be that your work on the typing of radiology would be a useful addition. If you would be interested in sharing our work, please email me.

My sense of radiology is that we will have a terminal in the courier room, one or more in the actual xray room, and one or more at the administration location. Administration gets an order for 'n' xrays from a doctor for a patient, marked as recieved. The terminlas in radiology are updated with unfilled orders, then marked completed; courier recieves a notice of xrays ready for pickup for delivery via several methods.

The state of the xray is readily available, as they get a lot of calls wanting to know the status of ordrd xrays.

But as my sense of what you are doing has more to do with the types of xrays and related issues, that could add great functionality to the program.