AnsweredAssumed Answered

Question How can I do this?

Question asked by kilbot on Feb 22, 2010
Latest reply on Feb 22, 2010 by philmodjunk

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

Outcomes