>Hi all:
>
>I have two tables with a one to many relationship. when i am on the parent table record i want a combo box to show only the corresponding records of the child table. Is there a property to filter out non related records
>
Why not populate it off a parameterized view with a field list (rowsourcetype = 6), and requery the p-view when the parent's record pointer moves? You'll want to incorporate logic to set the form's lockscreen property, set the combo's rowsourcetype to 0 momentarily, requery the p-view with the new key value in place, reset the rowsourcetype to 6 (fields) and respecify the rowsource property before resetting the lockscreen value of the form.