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]
