guy tanguay Posted February 4, 2005 Share Posted February 4, 2005 Hi, I am creating a Database that help me doing the bidding of projects that i could work on. (if i get the job!) I have 2 Tables : One being about the "project" (each record is data about a specific project) the second table is about all the different "parts" that need to be acheive in a "project". In the "Project settings" i have 4 different Rates : Rate A, Rate B, Rate C, Rate D. Each of those rate are for a entire day of work. So, i put a number for each of those Rate: 100$(RateA) , 200$(RateB), 300$(rateC) 500$(rateD). I could change later those -Rate- if i need to. After that, i would like to go on the "Parts" table and just puch a "Day number" for each "rate" as i do my evaluation bidding: see example= So, the amount i will have to charge you for me to acheive that "Part" is: "8X RateA", "0X RateB", "2X RateC", "1X RateD" And, as you can predict my Calculation field call "Part Total amount" will be someting like: = (#day*RateA)+(#day*RateB)+(#day*RateC)+((#day*RateD) but it didn't allow me to make that calculation. Well, i know that the calculation need to know from wich record i am referencing to in the "project" Database wich is someting that i don't know how to do. But in "project" i have a field call "Project ID" which is a 2 Letter id: ex: BR So, the 2 ultimatte questions are: The 1st one: How can I make, some of the records of the tables "parts" taking their referencing out of a specific record of the table "Project" using the "ProjectID" that i have already set in one of it field The 2nd question: Then, How can i make my Calculation field call "Part Total amount" work ! Thanks in advance for Helping me, I will fedex you a beer in the bar of your choice ! I think that will make me take a big step in to my FMP training guy Link to comment Share on other sites More sharing options...
This topic is 6614 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now