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
You need a third table so that you can match multiple businesses to multiple contracts. You can then use portals to this "join table" to assign companies to a given contract record. Define a number field in this third table to record your dollar amounts.
If you called your third table, Company_Contract, your relationships would look like:
Companies::BusinessID = Company_Contract::BusinessID (Allow creation and deletion for Company_Contract)
Contracts::ContractID = Company_Contract::ContractID (Allow creation and deletion for Company_Contract)
Place a portal to Company_Contract on your Contracts layout, add the BusinessID field, the Company_Contract::Amount field, plus the fields from Companies (such as company name) that you need.
To assign a company to a contract, pull up its record, select the BusinessID number for the company and enter the dollar amount into the amount field.