Data grid control

[Eric]

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,

[Albert D. Kallal]

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

[Eric]

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