Title
Load other table's record to portal tool
Post
Hi all FM experts,
I would like to ask a question for portal tool, let's say if I have 2 tables in the FM database , Table A- Purchase Order and Table B -Item Receiving.Table A 's form consist of a portal tool to allow user key in the item that going to purchase, Table B form also consist of one portal tool to key in all the received items. The question is , how to display all the Table A items in Table B's portal tool by selecting the PO ID as shown below. ( note : PO ID is a dropdownlist in table B's form)
thanks in advance..
regards
william
That's a bit confusing here.
It would seem your portal on the Table A layout would be a portal to Table B. How could you set up a portal to Table B on a layout based on Table B?
If you base your second layout on Table A instead of Table B, then you should be able to add a portal to Table B much like you have for you current Table A layout, but with the fields needed for this different layout. Since both layouts would be based on the same occurrence of Table A, changing layouts from one to the other would show the exact same list of Table B records in the portal.
Another option is to not use a portal on the Table B layout, but use a script that performs a Find or Go To Related Records to pull up the Table B records listed in the portal as a found set of Records for Table B. This would then allow you to use List or Table View to list the records from the portal on your Table B based layout.