I was wondering how others would go about creating a master detail form with a single query. Let's say I want to create a master detail form with the publishers and titles table in the pubs database. I created two data adapters to grab the tables, then placed them in a dataset, created a relationship (multiple titles per publisher), then created a master detail form. Not too difficult
What if I grabbed all data at once via a query with a join (e.g., SELECT * FROM Publishers INNER JOIN Titles ON publishers.pub_id = titles.pub_id) ? Would I still be able to create a master detail form? How would I go about dong it?