Hello,
Right out of the box that functionality is probably not possible. There are however possibilities to link lists with eachother. I am not a developer, but the kind of functionality you want is something that I would think is pretty common. If you fina a solution to it please post it here since that would be of interest for me and others.
If I find a good solution for it I will make sure to post it here.
Regards,
Thomas