Hi guys I'm building a small database for the company I work with but I found what seems to be a problem for me.

Referring to the pic attached:

the table OrdersIN has a portal on Orders IN Line Items.

On each row of this portal there's a button to "select" the row by changing the field "status" (on Orders IN Line Items of course) from 0 to 1.

I would like to have these selected rows (each representing a record from Orders IN Line Items and now uniquely identified by inorderID and status) to be displayed on a portal present on Invoice FUORI, but I can't manage to create a script capable of creating a new record in Invoice FUORI and having those selected rows displayed on "Invoice FUORI" portal.

(The "Invoice FUORI" portal displays records from "Orders IN Line Item").

I hope my enquire is clear, can anyone help me please?

I suggest that you add an Invoice Line Item table. This will give you more flexibility.

If, as per your final remark, FUORI has the same bas table as Orders in line items, you don't have to create new records, but re-define your FUORI portal.

Here's a simple example, with two different ways of implementing this feature.

If you use RalphL's suggestion, THEN you'd have to create new records.

ORDERSINLINE_eos.fmp12.zip

Thank you for your replies guys.

@RalphL: I previously created an Invoice Line Items table, but I tried to switch to this latter configuration to make it easier to link an incoming order to an outgoing invoice, and to be able to select the rows I need to be included in an invoice from an order.

@eos: I'm inspecting your solution right now, it's really neat and clear and I'm gonna try to implement it in my database, thank you very much! I'll let you know later!

Edit: I need to create new records in "Invoice FUORI" since I need a new serial for every Invoice I create. "Invoice FUORI" has a stand alone table, I'll try to figure out how to accomplish this, thanks!

"Invoice FUORI" has its own table, as well as "Orders IN", they both display data through a portal from the same table (Orders In Line Items). I'd like to accomplish that I select rows from Orders IN and display them in "Invoice FUORI" via a portal on "Orders IN Line Items". I'll work on that.

@eos: your solution is nice, but It's not exactly what I need, since you display 2 different portals (from the same table, Orders IN line items) on different layouts for the SAME table occurrence.

I guess I'll have to work with a script and some variable. I guess I'll have to save the orderlineitemID of the row I select in a $variable and the copy it in the portal of "Invoice FUORI" in a sort of while cicle. Can anyone help me please?

I made a mistake in the table relationships graph, the correct relationship should be as attached

Referring to the scheme attached in my previous post I can't understand this:

I can't put a portal on "Invoices_FUORI" displaying records from "Orders IN Line Items" that displays Orders In Line Items "biasing" the field ordersinlineitemID_kf. I mean, I'd like to choose an ordersinlineitemID_kf on a portal row and have the field Product Name (of Orders IN Line Items) displayed correctly. It shows nothing.

Ok I think I got it guys, if anyone is curious about the solution just ask and I'll post it