Using the list view to show several entries that share a comman fields (purchase req database)
I am a FMP newbie, I just learned the basics using an online coarse (lynda.com) and it has been great but I can't seem to make sense of this one and I am afraid I may have done something wrong at the outset of my design.
So I am making a purchase requisition database.
When a new record is created it is automatically given a serial number PR 001 ect.
Using a portal to a line items table the user can enter several line items that will all share the same PR number
the line item table is related to the PR table by the serial number.
So when I try to crate a list view showing all of the line items in a single pr that share the same serial it does not work and only shows me the first line item from each PR.
I imagine that this is something silly that I don't understand as of yet... any help would be appriciated, please let me know If i need to give any more details.