My IPeople

I suggest using index, drug.x.  This will at least eliminate inactive drugs from the search.

Just wondering if there is a more efficient way to write a npr report for physicians

to look up Drugs (ie by Trade or Generic).  We have one using the  Drug Dictionary with no index.

Page two is as follows:

    Select Field/Prompt or Value              Oper
 2  xx.name                                    IG
         Enter Trade or Generic Name:
 3  generic.name                               CO
         (c.xx.name)
 4  name                                       CO
         (c.xx.name)
 5  generic.id                                 CO
         (c.xx.name)

Select Relationship
C3!C4!C5

Page 3 is output is name and generic.name_" "_@strength_" "_@admin.form.name

Click reply to respond directly to the list. Unsubscribe at http://myipeople.com/forums/ForumSubscriptions.aspx