OPO Master Detail Problem
asaba
Help...help...
I am using Power Objects version 1.0.16. I tried to create master-detail
form with 2 fields as the relation key. So I put that two fields
separated by semicolon (;) on link detail column and link master column
properties of the repeater display. However I got an error....too many
column...
Anyone can help me ?
Thanks
Hannam Humin
Will Pedersen
You might have to create a view of the tables that concatenate the two
fields that you want to join the master and detail rows. I'm pretty
sure you can only put one column name in the 'link' fields, creating a
view and using it as the record source would allow you to use just one
column name.
Will Pedersen
Jason Byors
asaba wrote:
Help...help...
I am using Power Objects version 1.0.16. I tried to create
master-detail
form with 2 fields as the relation key. So I put that two fields
separated by semicolon (;) on link detail column and link master
column
properties of the repeater display. However I got an error....too
many
column...
Anyone can help me ?
Thanks
Hannam Humin
The best way I can think of to handle that problem is to create
another column on each table that is the combination of the two
columns that you want to use in the link. For example column C =
column A & column B.
I don't think OPO can handle linking on two columns.
JB
Eric Therrien
With a little searching (and also remebering that IT WAS POSSIBLE to do
what you'r trying to do), I came up, in the OPO On-line help, at the
"LinkDetailColumn property" entry, down at the bottom, with an explanation
of how to do it. Here's the extract from the help:
Multi-Segmented Keys and LinkDetailColumn
Note that you can enter a multi-segmented key for LinkDetailColumn. By
entering column names separated by a semi-colon (;), you specify the
segments
of the key. You must also enter the same number of segments for the master
recordset, through the LinkMasterColumn property, as well as an identical
number of containers for LinkMasterForm.
I've never made any (and I'm a little rusty with OPO), but if I'm reading
well, what you did was fine, exept that you forgot to specify the same
thing on your Master form.
Also, I'm reminded to something I've read in the readme file about Blaze.
It doesn't support multi-segmented key, altrought you can specify one (or
should I say many) multisegmented key in the editor. That's because PO7
(and other DB) does support it. So that might explain your problem (that
is if you'r using Blaze).
In article <31C730...@rad.net.id>, asaba <as...@rad.net.id> wrote:
> Help...help...
>
> I am using Power Objects version 1.0.16. I tried to create master-detail
> form with 2 fields as the relation key. So I put that two fields
> separated by semicolon (;) on link detail column and link master column
> properties of the repeater display. However I got an error....too many
> column...
>
> Anyone can help me ?
>
> Thanks
> Hannam Humin
--
_____________________________________________________________________
Eric Therrien Internet: eri...@montrealnet.ca
Club Informatique Longueuil: http://www.connectmmic.net/users/cil
Président du Club Informatique longueuil inc Montreal, PQ
_____________________________________________________________________
Raul Enrique Mengod Lopez
In article <31C730...@rad.net.id>, asaba <as...@rad.net.id> wrote:
>Help...help...
>
>I am using Power Objects version 1.0.16. I tried to create master-detail
>form with 2 fields as the relation key. So I put that two fields
>separated by semicolon (;) on link detail column and link master column
>properties of the repeater display. However I got an error....too many
>column...
>
>Anyone can help me ?
>
>Thanks
>Hannam Humin
>
It is possible to do what you're trying to.
Specify both columns separated by a semicolon on the LinkMasterColumn and
LinkDetailColumn.
And specify the Form where the columns should link to. One form per Column.
If both columns are linked to the same form just specify two time the name of
the form separated by a semicilon.
RAUL.
UNIVERSIDAD POLITECNICA DE VALENCIA
CN DE VERA S/N
46022 VALENCIA
email: rme...@upv.es