Linking table to form

[Guest_imported]

I inherited a pharmancy program written in paradox and am just learning how it works so I may not use the correct terminology. I am having a problem because it appears that a link has disappeared. Previously, when we entered the medication name in the order form, it automatically pulled over the charge code, for and units from the table. ( the table consists of the medication name, the charge code, the units and the form) Now when we use the look-up we are able to find the medication but it only inserts the medication name on the form and does not pull the rest for the information from the table. Can anyone tell me how to fix this problem? I can use all the help I can get!
Thanks!

Julie

 

[Langley]

Assuming that this was not a custom (read: specially coded) method for doing look-ups, then it is a simple thing to check. Restructure the table which calls the lookup value. Click on the Table Lookup tab. Make sure field relationship is right and that the radio button for Applicable Fields is checked. If it is already checked, then you may have a damaged table - or it is possible that someone has renamed some of the table fields. Use the table repair utility to examine the main and lookup tables for problems. However, if Current Field is checked instead of Applicable Fields, check Applicable Fields and save the table - that will probably solve the problem.

Mac

"Do not delve too deeply in the arts of your enemy and so become ensnared by them"

langley_mckelvy@cd4.co.harris.tx.us

 

[footpad]

Julie,

It could be one of a couple of things, each related to the lookup definition:

1) If the lookup definition was recently re-created, it sounds like the Lookup type was not set to "Applicable fields" (Paradox 9 and 10) or "All Corresponding" (older versions).

2) If either the data table or the lookup table have been restructured recently, it's possible that either the field names of the corresponding fields were changed or the data types were changed to non-compatble values.

The idea behind the "Help and Fill" process is that lookups will only copy multiple fields when the names are the same and the field types are compatible.

In this case, "compatible" means "where they're similar enough that data wouldn't be lost when copying a value." For example, you could probably create a corresponding lookup that takes an integer value and places it into an alpha column; however, you probably wouldn't be able to do the reverse. (I say probably because I've always used the same field types when create corresponding lookups. This is the preferred approach.)

Now, if neither table has been restructured recently, then it's possible that the lookup table (or one of its indexes) have become corrupted. In that case, Tools | Table Repair may help.

Hope this does...

-- Lance