Display one or two record from one portal to another

[Mark Gimpaya]

Hello everyone. I am from Philippines and i'm just a beginner in filemaker and I want to ask how to achieve this process

I have a record here in 'Books Tab' in portal from another layout . What i want to happen is when i click the 'Proceed' button above, i want to display these records automatically in another portal in also another layout whether it is one record, two record or even more record.

This is the layout where i want to display automatically the records of Books and also the amount. I don't have sufficient knowledge on how to do it in Looping.

 

Thank you

[LaRetta]

Hi Mark! 😃

To properly advise, we'll need to understand your structure but let's see if we can move you forward a bit:

You currently have a relationship from the parent table (the table your main layout is based upon) to the Books table (portal of Books).  So, while on that parent layout, you click a button called 'proceed' above,  it can fire a script with:

Go To Related Record:  From table:  Books  Using Layout:  your new layout and probably Show Only Related Records

This is a far as we can go unless I see your graph or understand your structure.  I would question why you are jumping to another portal of Books instead of a simple list or card layout based upon the Books table. 

What is critical for us to understand is 1) the table name the layout is based upon and 2) the table name a portal is based upon and what is the relationship between the two (how are they joined in the graph).  

The easiest thing to do is suggest you attach your file. 

[LaRetta]

Hey Mark, on second thought ... if you want to add the books in the portal to an Invoice LineItems table by creating new records with those charges then we can do that as well.  We'll need to make sure you have a normalised structure though so fill us in.  👆