How to display on a portal only selected rows of another portal

[cruijff]

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?

[RalphL]

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

[eos]

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

[cruijff]

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!

[cruijff]

"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?

[cruijff]

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

[cruijff]

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.

[cruijff]

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