Showing data in portal from 2 tables

[bigmac]

Invoice_analysis

http://img519.imageshack.us/my.php?image=bild1vo9.png

I have a tricky one that I can't seem to figure out how to solve.

First:

I have a table with invoices and invoice totals

Second:

I have a table called invoice_analysis where I group say 10 invoices in a shipment, ad a freight total for that shipment, in order to calculate margins etc.

Here's the relationship:

http://img261.imageshack.us/my.php?image=bild2od0.png

Yellow box:

Invoice_header contains date, total sum etc it has a relationship with "Inleverans_rader" wich contains the individual items on the invoices. This table is not relevant here though

"Fraktanalys_huvud"

Contains the "container" for the invoice analysis, ie the analysis number (3000 in first picture), it has a relationship to the yellow box via invoice number. This way, entering an invoice number in the analysis window, should make the invoice data, ie invoice total, date etc pop up in the container. The invoice number together with the analysis number should be stored in the "Fraktanalys_rader" table for later retrieval.

Here's the problem:

How do I add the invoice number in the anlysis window??? If i move the invoice number field out of the portal, it enters the data, but I can only add one line, if I move it inside the portal, it works, but I soon as I delete the row, i cant enter it again. How should this be solved? 2 portals side by side?

Edited July 19, 2008 by Guest

[bigmac]

solved -)