One of the forms in the application that I am working on contains a LISTBOX that is used to display related records. One record on this form may have n related records from different tables. As additions and modifications are made to the related tables, what is the best way to update the contents of the Listbox? My first thought was to place a script in or call a stored procedure from the CREATE event of the form that would populate the listbox. It would be nice to 'refresh' the contents of the listbox immedately after new or changed records from the related tables are saved. Any suggestions for a good way to handle this? Thanks.

Using a Stored procedure is a good solution, for example….

We have a stored procedure called BUILD_LIST which you pass the window.control name and a parameter, eg ll, [i]nsert, elete and the item id (or null for all).

Depending on the parameter, get the table ids and populate.

For [i] and you just add the id in the appropriate place using locate, or on the end if your list box controls are sorted.

This way you dont have to rebuild the entire thing every time a database record is added or deleted.

Assuming you know that the related tables have been updated, just send and insert message to the list box with the new information. It will add it right in.

[email protected]

Sprezzatura, Inc.

View this thread on the forum...