>>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, do you want to adjust listbox 2 to show just the items linked to the value in listbox 1? I do that with a parameterized view for the second listbox. In the InteractiveChange for Listbox1, I requery the view with the correct parameter value, then requery Listbox2.
>
>HTH

Barbara, that's one method I haven't tried. I'll check it out. Thank you.