Checking for existing entry in Purchase Order
I am very new to Filemaker Pro so I ask for your patience. I am creating a purchase order system based around the Invoices starter solution. I would like to be able to make sure that an item is not entered into a purchase order more than once. When I enter an item number I would like to scan the portal of the current PO and make sure it is not already in the portal for the PO I am working with. If I just do a quickfind for the item number then I pick up the item number from other PO's that have already been entered. Is there a way to limit my search to just the portal I'm currently working with? Any help or suggestions would be greatly appreciated.