Question How can I do this?
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