Newbies Loweded Wookie Posted August 3, 2014 Newbies Share Posted August 3, 2014 Hi all, I'm new here and new to FileMaker Pro and I need a bit of help. I'm creating a call management system and I have three table that I need to interact with each other. The first is the main table called Job_Details which includes a field called Client that is a list based on the table Clients. The third table is Job_Updates which is basically the updates against the job in the Job_Details table. In the Job_Updates table there is a field called Amount which is the rate to be charged for each client. What I am trying to achieve is that when I select the Client from the drop down list in Job_Details it automatically adds the rate into the Amount field on the Job_Updates table WHEN the job update is created. Currently I have a series of IF statements that I have to manually add which is a dumb idea because soon it will become unwieldy. How do I go about this? Thanks for your help. Link to comment Share on other sites More sharing options...
Lee Smith Posted August 3, 2014 Share Posted August 3, 2014 Please post a copy of your file so that we can your fields, relationships, etc. Here is a link for you Attach File Link to comment Share on other sites More sharing options...
comment Posted August 4, 2014 Share Posted August 4, 2014 What I am trying to achieve is that when I select the Client from the drop down list in Job_Details it automatically adds the rate into the Amount field on the Job_Updates table WHEN the job update is created. Do a lookup. Link to comment Share on other sites More sharing options...
Newbies Loweded Wookie Posted August 4, 2014 Author Newbies Share Posted August 4, 2014 Here's the file. Don't worry about the fact I have a Company field and a Client field as this is by design as the client isn't necessarily the Company. I don't understand how the lookups work. Do they need to work based on calculations or scripts or what? How do I look up the values when the other field is changed? Thanks heaps for your help. Field_Engineer Clone.fmp12.zip Link to comment Share on other sites More sharing options...
Siva D Posted August 11, 2014 Share Posted August 11, 2014 Make sure "ID Clients" field at Job_details table is loaded using a popup menu or drop down list. Create a look up from amount field to Client Billing Rate field of client table. See the screen shots. Â Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3557 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 accountSign in
Already have an account? Sign in here.
Sign In Now