Thanks for responding, I did some looking and called Filemaker as I am on a demo version to evaluate. They pointed me to BPS to check out what they have. The demo version looked good but a little more then what I was looking for so I have been using thier template and modified for my demo. At this point I still cannot get the add from catalog to work. The idea here is that a Project Manager can go to the AV Materials Pick Request and create a new pick. From there they will press a button to add product. From there it will go to the catalog and then they can browse the catalog and select the items they need, this in turn will add the product to the pick request. what would really be great is if they could enter the quanity they wish from the pick catalog. I was able to use portal and enter a part # and it would fill in correctly. I also am using a table for this so that if a price change happens it does not effect already entered orders. I have attached a file with the scripts. The script I am working with is ADD. I appreciate any help you experts can give a beginner, I am sure this product is what our company needs but I need to prove to the correct people that this product can do it.
Thanks Again, Mike
Test_Data_Base.zip