By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,039 Members | 1,831 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,039 IT Pros & Developers. It's quick & easy.

Master Detail Question

P: n/a
I Have a form with two datagrids bound to two tables in a dataset. The
top datagrid is a master and the one below it is a detail.

I want to be able to click on a row in the master and fire an event to
update the botton grid with detail records related to the master. I
havnt been able to find such a simple way to do this. Is this correct?
How can I do this?

jwc

*** Sent via Developersdex http://www.developersdex.com ***
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi Jim Bob

I assume that the "datagrids" are subforms, with their record sources
the master and detail tables.

Put a control on the main form with its control source something like:

=[MasterSubform].[Form]![MasterId]

Then link the main form to the detail subform, using this control as
the master field and the foreign key in the detail table as the detail
field.

HTH

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.