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]
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
