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.

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.

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

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

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

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

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