Can I show a related record by not using a portal?
Yes, you can put the fields in related table.
Thank you for the reply. I tried your suggestion, I put the fields in my related table but it shows all the records from my main table.
What Im trying to accomplish here is to show my expiring materials for this month.
Sorry I can't get you. "For this month" seems you are trying to show "some records that is in a month", not "a related record".
The way I wrote does "show data from a related record which is first record if portal is there".
Retrieving data ...