Showing / Hiding Records
Good afternoon -
I put together two layouts (Purchase Orders and Check Reqeusts) using one table and global fields so each form will have the next available number (i.e., PO #55000, 55001, 55002, etc; Check Request CR11, CR12, CR13, etc).
My question is - since both forms are using the same table - all records appear (4,000+) when opening the form. When selecting either the PO or Check Request, how can I show the records for that particular form (i.e., PO record quantity - 3,500; Check Request - 500). Do I need to put a script together, or is there an easier way?
Thanks in advance for your assistance.