I have recently been using the following PROPERTY command that is great for
what you are
looking for: (Taken from the PROPERTY command syntax builder) Requires 7.5 or
higher though.
I did not see the original post, so I am not sure what you are using.
-Bob
Syntax:
PROPERTY TABLE 'FormTableName->SEARCH->FormColumnName->' varname
Notice the database QUOTE character surrounding the
FormTableName->SEARCH->FormColumnName->.
SET VAR vSearchString TEXT = NULL
SET VAR vSearchString = +
('PROPERTY TABLE Customer SEARCH->'+.vColumnName+'->'+.vSearchValue)
&vSearchString
RETURN
--
Thompson Technology Consultants
LaPorte, IN 46350
219-363-7441
-------------- Original message --------------
From: Emmitt Dove <[EMAIL PROTECTED]>
>
> I neglected to mention this requires 7.1 or better ... and, you can
> copy your existing form, changing the table upon which it is based in
> the process, so no need to rebuild the form if you use the same
> column names in the view.
>
>
> >One way is this:
> >
> >1) build a view on your table containing the values you want to
> >display plus your part number column
> >2) base the form on the view
> >3) handle the part number selection however you'd like
> >4) in an eep after part number selection, do this:
> >
> > PROPERTY TABLE viewname 'CLOSE'
> > -- drop your view
> > -- recreate your view with a WHERE clause limiting it to your part number
> > PROPERTY TABLE viewname 'OPEN'
> > RECALC VARIABLES
> > RETURN
> >
> >>Ok, I've got a form associated with a table. DB Labels show table data
> >>all over the form. Want to capture a value (a part number) from the
> >>user with a Variable Edit control then have the form display all the
> >>associated data for that part number. I need to display with DB Labels
> >>so I can locate the data specifically. No matter what I try, I can't
> >>get the form refreshed without leaving the form. What am I missing?
> >>
> >>Should be simple...
> >
> >Emmitt Dove
> >Manager, DairyPak Business Systems
> >Blue Ridge Paper Products, Inc.
> >37 Sybil Ave
> >Branford, CT 06405
> >(203) 643-8022
> >[EMAIL PROTECTED]
> >[EMAIL PROTECTED]
>
> Emmitt Dove
> Manager, DairyPak Business Systems
> Blue Ridge Paper Products, Inc.
> 37 Sybil Ave
> Branford, CT 06405
> (203) 643-8022
> [EMAIL PROTECTED]
> [EMAIL PROTECTED]
>
