Working with portals to show data
I created a layout to use in form view, that shows how many words a student has read correctly. I want the layout to show a box per word per trimester next to each word. (e.g.: T1 box= blank, T2 box= "X", T3 box = "X").
I've created a table with alll the fields I need to input data. I also created 3 duplicate tables of the same table, each representing one trimester. The relationship is:
Table HFW record ID = Table HFW T1 record ID
Table HFW trimester = Table HFW T1 trimester if = to 1
On the layout I put a portal that gets data from table HFW T1. The filter states: Table HFW record ID = Table HFW T1 record ID
I then duplicated the portal to do similar for T2 & T3 data.
It doesn't work.
Does anyone know how to make this layout work?