7 Replies Latest reply on Feb 6, 2013 4:37 PM by MeganHall

    Non Expert needs Help -- linking multiple records in one table to another

    MeganHall

      Title

      Non Expert needs Help -- linking multiple records in one table to another

      Post

           Hi there,

           To start out, I am trying to self teach myself Filemaker Pro 11.  I purchased "The Missing Manual" and have scoured websites, forums, and You-Tube.  I'm hoping my answer is out there -- I may just not know the key search words to define my question.  Any help from any kind souls out there would be greatly appreciated.

           My issue:  I work for an A/V contractor and we want to be able to create a work spreadsheet with a list of parts needed along with the manufacturer and cost to include when we send a quote out to customers.  I want to create a system where I can have one database (or table if you think that is smarter) for Parts.  Fields in this table would include Part #, Part Name, Description, Cost, and Date the price was last updated.  

           In a separate Table/Database, I want to create a form that lists the client's name, address, quote number, etc.  But then I want to be able to access the Parts table to impute all the equipment needed for the job.  The form should have enough room for 50 lines of parts/equipment.  

           Is there a way to do this?  I know I must be missing a step because when I try to do a portal, I can only seem to get one part number and corresponding info for that part.  If I try to do a second, it duplicates the first part number.  The same is true when I tried to do a Dynamic menu/Value List. 

           Thanks again for any ideas, assistance!