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

Data grid control

P: n/a
I create form with master detail relation ship. It shows two data grid
control. I want to remove one. I want to use one grid control by which
i can add delete data in both tables.

Thanks,

Aug 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It is not clear here, but by two controls...do you mean two columns of
display, or is there in fact
two actual "grid" displays.

I *often* use two sub-forms to display "many" of the "one" side of a
relation on the left side of the screen,
and then on the right side show many for each of what is selected on the
left side.

Here is some screen shots of what I mean:

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm

the above might give you some good ideas. The last screen shot is a classic
example of splitting out cheque funds for a given person to multiple
accounts.

However, if you want data from both tables to be shown on a single grid, the
build a query that joins the two tables together, and then build a continues
form based on that query.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 14 '06 #2

P: n/a
I am sorry. I mean it shows 2 data controls. One for main form and the
other for subform. Is it possible i use one control to add, delete edit
data in both.

Thanks,
Albert D. Kallal wrote:
It is not clear here, but by two controls...do you mean two columns of
display, or is there in fact
two actual "grid" displays.

I *often* use two sub-forms to display "many" of the "one" side of a
relation on the left side of the screen,
and then on the right side show many for each of what is selected on the
left side.

Here is some screen shots of what I mean:

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm

the above might give you some good ideas. The last screen shot is a classic
example of splitting out cheque funds for a given person to multiple
accounts.

However, if you want data from both tables to be shown on a single grid, the
build a query that joins the two tables together, and then build a continues
form based on that query.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Aug 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.