>Situation: I have a tabled called BAYLOR. The fields within this table are CDC_ID(c), EXP_ID(C)There are five (5) records with the CDC_ID 557-5555-88888. Each record has different EXP_IDs. I need to be able to display all EXP_IDs that pertain to that particular CDC_ID on a form.
>
>How can I?
There are a bunch of different ways to do this. You could create a view that filtered this info. Or you could just use a SELECT command to build a cursor with those records. The SELECT would look like:
vp_Filter = "557-5555-88888"
SELECT EXP_ID;
FROM BAYLOR;
WHERE BAYLOR.CDC_ID = ?vp_Filter;
INTO CURSOR v_Baylor
Now you can bind this cursor into a ListView, grid, etc.