Show all records from one table in a portal in another table
I would like to do following:
I have a table with frozen products (~400). 40 of these I have in a special freezer. In the freezer each of these 40 have a specific box which has a box number. I have one large table with all the detailed info about each of the ~400 product (called main layout). Then I have created one table with only the product ID# and the location in the freezer (freezer layout).
What I would like is a portal in the main layout that shows all the records from the freezer layout (ordered acording to a sorting number). So that I can see what is in all boxes in the freezer at the same time while I still can see the detailed record info on the main layout for one record. Is this possible??