For example, let's say I want to create a form that lets me select an author's name from a dropdown that pulls names from a names table. I would like the subform to display all of their books. 

The same with a form for music artists that would list all of their songs in the subform.

When I create the form and subform, I link the fields via the column properties as instructed in a knowledgebase article but nothing ever happens. When I launch the form it just lists nothing in the subform when I select the name of an artist or author. Do I need to add deluge code to make anything work???

Thanks