General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Using views to populate list box with multiple records
HI everyone!
Let me thank everyone for helping me out.
I have another question here, this time about using views. Can anyone tell me if it is better to create local views and then populate list boxes with multiple records by putting a filter on the parent record.
Here is the code which I am using in refresh procedure of the listbox:
cparentTable = Alias()
* selects the view
SELECT zoneview
* sets filter on wcdet.wcnumber<-- which is a field from parent table
SET FILTER TO ALLTRIM(wcdet.wcnumber) = ALLTRIM(zoneview.wcnumber)
* Populating list box with relevent field values
Rowsource = 'zoneview.zone'
Rowsourcetype = 6
SELECT (cparentTable)
OR, what if I put SQL SELECT Statements in the refresh() for each list box and try to retrieve this data.
Also, how should I manipulate the data in a view by using a mover lists.
Please advise me as what do I need to do from here on.
THANKS!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only