Not sure if or how to do this but here is what I would like to do.

I have built an event planning database. I need to add flights to events. I also need to assign passengers from my personnel table to each flight.

What I would like to do is add a flight and assign it to an event. after that I want to be able to select what passengers will be on that flight have my value list only show personnel from the event that this flight is assigned to.

Hope that makes sense. Thanks for the help.

I've modified the demo that I provided in your post about Companies and Events.

Events-2.fp7.zip