Hi, excuse me my english.
I have a problem relationed with Master - Detail forms to data capture.
The situation is: I have 2 tables. The first is: "Group" (master) and second is "ProductorGroup" (Detail). The description is:
Group: "CodGroup" serial NOT NULL,
"CodMun" character(5) NOT NULL,
"CodDpto" character(2) NOT NULL,
"CodRegional" smallint NOT NULL DEFAULT 0,
"CedulaContratista" double precision NOT NULL DEFAULT 0,
"Vereda" character(50) NOT NULL
The primary key is: CodGroup
ProductorGroup: "CedulaProductor" double precision NOT NULL DEFAULT 0,
"CodGroup" integer NOT NULL,
"FechaUpdate" date NOT NULL DEFAULT now(),
"Nombre" character(50) NOT NULL,
"Telefono" double precision NOT NULL,
"Finca" character(20) NOT NULL,
"Ha_finca" integer NOT NULL,
"Ha_cultivo" integer NOT NULL
The Primary Key is: CedulaProductor and CodGroup.
I generate the php code with phprunner 5.2.
In tables option, create a table link.
Master: Group -> Detail: ProductorGroup.
Link Field:
CodGroup and CodGroup
Master page Settings
(ok) Display Number of Child records
Display child records on:
(ok) List page
(ok) View page
(NO) Add page
(NO) Edit page
Detail page settings:
(Ok) Display master table info on details page
In events options, table: Group.
Table Events / Add Page / After Record added, insert the next code:
header("Location: ProductorGroup_add.php?mastertable=public.Group&masterkey1=" . $keys["CodGroup"]);
exit();
The problem is, the redirection page result is:
http:// myserver / ProductorGroup_add.php?mastertable=public.Group&masterkey1= and the value of masterkey1 was lost.
Help me. Thanks
Mauricio Zea
