4 Replies Latest reply on Feb 22, 2010 10:59 AM by philmodjunk

    Question How can I do this?

    kilbot

      Title

      Question How can I do this?

      Post

      Okay I have 2 tables one table list all of the businesses that I work with informations. I have another table that is used to evaluate contracts.

       

      On any given contract I have multiple business that perform work and give me a quoted amount for the work performed. All of the business have a ID number that has been assigned to them.

       

      WHAT I AM TRYING TO ACCOMPLISH

       

      I would like to be able to place a business id number into a box and it would automatically lookup the name of the business and then next to that I could place the dollar amount for the job. Remember I have multiple businesses on each contract so I need to be able to do this up to 15 times or more. Lastly I want to be able to total the amount of all of the bids from the businesses on that contract.

       

      HOW CAN I DO THIS

       

      I pretty new to filemaker.....

      Do I use a portal

      Do I use repeating fields

      Do I ...........

       

      I have already related the 2 tables by the Business ID#......Is this correct?

       

      Please keep it simple so I can understand

       

      Thank you