Creation of related record to be shown in portal problem

[Ray H]

I have a database with only two tables and one layout. One table is invoice the other is invoice lines.

From the layout invoice (Table:Invoice) I would like to enter data into three fields into a related table (Invoice Lines) The invoice lines would then be displayed in a portal.

I have been trying to work this out for days if anyone could help with some advise I'd really appreciate it.

[Walter B]

I wasn't able to open your attachment, but my guess would be that you didn't click on the "Allow Creation of Record..." box in the relationship dialog box.

[Lee Smith]

If Walter's suggestion doesn't do it, then I suggest that you Zip your file and resubmit it.

[color:blue]a lot of us have trouble with .rar, whereas the zip seems to work for all of us.

Lee

[Ray H]

Yes I already knew to do what walter suggested, what I am trying to do is a little more advanced than that if you could take a look at the new attached zip file id appreciate it.

related_portal.zip

[comment]

You need a script for this. Also, the "scratch-pad" fields should be global, since you don't really need to store this information with the invoice. See attached.

related_portal.fp7.zip

[Ray H]

Thankyou very much, this was exactly what I wanted to acheive. Many thanks.

[Ray H]

Just one more question if I may, what would the best way of printing this invoice. Many thanks