almost there -> gnue :-)

[Mike]

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