|
Home > Archive > Getting Started with dBASE > October 2006 > Form Design
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Michel PAIN 2006-10-28, 7:16 pm |
| Hi,
When designing a form, if a grid relates to a table CHILD of a parent table, data doesn't appear in design mode and it's impossible to arrange the different fields on the grid.
The method I use is : Go to the dQuery module
Cancel the Parent/ child link
Design the grid
Go back to dQuery
Re-establish the Parent/ Child link
not really elegant nor efficient !!
is there a smarter way to proceed ???
Thanks to give me a little bit of light on the dark road of learning.
Michel
| |
| Roland Wingerter 2006-10-28, 7:16 pm |
| Michel PAIN wrote
> Hi,
> When designing a form, if a grid relates to a table CHILD of a parent
> table, data doesn't appear in design mode and it's impossible to arrange
> the different fields on the grid.
>
> The method I use is : Go to the dQuery module
> Cancel the Parent/ child link
> Design the grid
> Go back to dQuery
> Re-establish the Parent/ Child link
>
> not really elegant nor efficient !!
> is there a smarter way to proceed ???
--------
I am not sure why you have difficulties. This is what I do using the object
inspector:
1. Set the grid's datalink property.
2. Click on the "columns" property and select the columns I want to include
in the grid.
Roland
| |
| Gerald Lightsey 2006-10-28, 7:16 pm |
| On Thu, 26 Oct 2006 04:15:40 -0400, in the dbase.getting-started group,
Michel PAIN said...
> When designing a form, if a grid relates to a table CHILD of a parent
> table, data doesn't appear in design mode and it's impossible to
> arrange the different fields on the grid.
>
> The method I use is : Go to the dQuery module
> Cancel the Parent/ child link
> Design the grid
> Go back to dQuery
> Re-establish the Parent/ Child link
>
> not really elegant nor efficient !!
> is there a smarter way to proceed ???
>
> Thanks to give me a little bit of light on the dark road of learning.
The way I do these things is to...
1. Create my data module first in dQuery.
2. Close dQuery and name the data module.
3. Start designing a new form and drag the data module from step 1 onto
it from the Navigator.
4. Drop a grid onto the form.
5. In the data link property of the grid click the down arrow and select
the parent query.
6. In the columns property of the grid click the wrench icon.
7. In the dialog select the various fields I need from parent, child and
sibling queries in the order I want them. (These will replace the
default fields from the parent query established in step 5).
8. Finally, click the grids columns property and use the "I" button to
drill down for each column and fine tune its members/properties as
require.
Obviously the query relationships within the data module and the fields
selected for the grid have to make sense together in order to have a
grids with a display that makes sense.
I never have to go back to dQuery unless I have to set up another table
instance and/or index and/or master row/master field relationship within
the data module that I forgot to set up initially.
If you have a lot of queries in your data module selecting the queries
and fields from the tiny dialog of step 7 can be quite tedious.
Gerald
|
|
|
|
|