Feyo
asked on
Creating master-child form with two tables and a relationship versus one query
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?
Thanks.
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?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER