>>I want to have two listboxes on a form with a one to many relationship. I have tried several different ways of doing this and each one has problems or bugs. I'd love to hear from someone who has done this about what you use for the Rowsource for the child listbox and how you set up the one to many relationship.
>
>Peter;
>I've developed a couple of screens in one of my project usign fp 2.6 which worked like this:
>- one of the screens used 3 tables Product, Common Components, Unique Components. The three tables are displayed in listboxs. As you navigate through the product list, the two other windows are updated accordingly. The trick I used there was I saved the selected record in product listbox to a variable. In the WHEN clause I compare the current record in the list box with the variable, if they are not the same, that means I have to run two queries to update the cursors displayed for common and unique components.
>
>hope this helps
>
>
>Kia :o)

Kia,
I should have mentioned that I'm using VFP. I finally found a workaround for the bug that was causing me problems and I've got it working fine now. Thanks for your response.