I need to build a form with a many-to-many relationship. There are three tables involved:

who_uses index on phone + app
applications index on apps
users index on phone

Here's what I want to do: A master-slave form using the users table as the master and the applications table as the slave in a grid. I know from reading the VFP 6 user guide that a "junction table" is needed to resolve the many-to-many relationship into two one-to-many relationships, but so far I cant figure out how to get the grid to display any moer than one record in the applications table.

How can I do this? I'll be adding functionality for the user to be able to add applications, but first things first- how can I display all of a user's apps in this situation? Please let me know if I've supplied info to define the problem properly. Thanks!


Henry