almost there -> gnue :-)

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Mike
Date:  
Subject: almost there -> gnue :-)
Can't recall who recommended gnue for my simple
invoice system, but thanks :-)
Took a couple days break from the install problems,
and within a hour or two today, I have most of it working.
This is neat stuff.

Anyway, my first question:
I have created a stupid simple database with a couple
tables. Se below:
-----------------------------------------------
DROP TABLE IF EXISTS invoice;
CREATE TABLE invoice (
invoice_id int(10) NOT NULL AUTO_INCREMENT,
name varchar(30),
company_name varchar(40),
address varchar(80),
city varchar (40),
state varchar (40),
postal varchar(20),
phone varchar(30),
email varchar(80),
comments text,
PRIMARY KEY (invoice_id)
);
DROP TABLE IF EXISTS invoice_details;
CREATE TABLE invoice_details (
invoice_details_id int(10) NOT NULL AUTO_INCREMENT,
invoice_id int(10),
description varchar(200),
qty int(3),
cost varchar(10),
total varchar(10),
PRIMARY KEY (invoice_details_id)
);
-------------------------------------------------
Running the advanced wizard in gfdesigner allows me to call
the master/detail tables and link them up. Everything works
the way I expect except that the detail table does not get
the master key (invoice_id). In case I haven't stated it,
this is linked to a MySQL database (3.23.49). The entries
in the invoice_details table for invoice_id are all NULL.
Anyone?

Second question, can someone point in a a direction to run
a report against this data. gnue/forms is already installed,
but I haven't firgured out this process yet?

v/r
Mike