Link to home
Start Free TrialLog in
Avatar of Feyo
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.

ASKER CERTIFIED SOLUTION
Avatar of Dabas
Dabas
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Feyo
Feyo

ASKER

Both suggestions work fine. Thanks!