I'm new to these forums so hopefully I'm posting this is the right spot. I'm fairly new to the more complex elements of Filemaker and have just started getting into Portals. I have two databases, one for Projects (quoting, invoicing) and one for inventory. Through portal filtering I've been able to pull up inventory based off of the type of material chosen in the PROJECT that matches the material in INVENTORY. Specifically, if I'm quoting Material "A", the portal only shows the available material "A" from inventory.
Is there a way for me to go one step further and 'tag' the available inventory for a specific project? For instance...
1. Project 'Smith' requires two pieces of material "A"
2.The portal of INVENTORY shows three available, "A-1, A-2, A-3" along with the value of each
3. I want to tag specifically A-1 and A-2 and have the sum value of those become a value in my project database for this specific record only. Each project is a record.
I assume that I could filter matching the PROJECTS::Project Name = INVENTORY::Project Name, but that would require going into inventory and tagging the material. I could also do this by typing in the name of the project in the inventory portal in the PROJECTS, but I was hoping to create an easier method like maybe a check box or something. Something I could click and it would put the name in and then give me the value of the material.
Any advice would be appreciated. In the mean time, I'm going to use two portals, one that allows me to type the project name into INVENTORY from the PROJECT database and the second that specifically shows what inventory I've assigned to the project.