Jump to content
Tony Rod

Independent Contact Field in Invoices Module

Recommended Posts

Hi everyone,

I'm using Fm Starting Point 4.6.6.b for a personal project but I don't know if you can help me with some problem I have right now.

In the Invoices module, there's a field for Contact info (Contact_Name) where you can search for a specific contact just clicking on the lens button and when you found the desire contact, the Biil To and Ship To tabs are updated with contact information. So I duplicate the Contact field, copy the buttons and rename it to Contact Ship and also I modify all the scripst for Contact (Contact_Name) update Bill To tab, and Contact Ship updates Ship To tab, and here is the problem; every time I choose a contact name in either of the two contact fields (Contact or Contact Ship), automatically puts me the same contact name in both fields  (Contact an Contact Ship).

What I need is that If in Contact field I choose Morgan Vinshire, and in Contact Ship I choose John Smith, those names remain in their respective fields and not like now that if I choose Morgan first as a Contact and then I choose John Smith for Contact, then Contact with the first name (Morgan) change for John Smith.

I know this is difficult to explain and also confusing but I hope yoy understand what I mean.

 Is there any solution to this problem?

Thank you in advance.

Share this post

Link to post
Share on other sites


In order for those fields to work the way they do, a relationship must be formed to the Contacts module for each separate Contact you are trying to relate.

Additionally, each Contact you are trying to relate must have it's own ID field that relates back to the Contacts table.

So you will need a (ID_Contact_Shipping) and a (ID_Contact_Billing) in addition to the (ID_Contact) field that exists.

Those two new fields will need to be related from Invoices to Contacts.


If you are looking to learn more about the FileMaker Platform, as well as relationships, scripting, and other import development tasks, Richard Carlton Consulting offers a FileMaker Pro Video Training Course here: http://www.learningfilemaker.com/

Additionally, we offer One-on-One FileMaker Coaching to help you learn, while doing actual work on your solution. If you are interested in that, email us at support@rcconsulting.com



Jonathan Hogle

Share this post

Link to post
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    9 members have viewed this topic:
    ddinisco  Josh Ormond  BruceR  Lee Smith  doughemi  MikeKD  Ocean West  bcooney  LaRetta 
  • Similar Content

    • By Stephen Murphy
      Hello All
      I have an excel spreadsheet with contact names, company names , email, phone etc.
      I imported the company details email & phone to the Accounts module and I imported the contact names & associated account name to the Contacts module
      How do I "relookup"  the account names so that the contact is assigned to the Account in the accounts module?
      Stephen Murphy
    • By bwinger
      Hi there, 
      Would really like to be able to automatically add Invoice and Estimate information into the Calendar view when a new Invoice or Estimate is created, is this possible?  Struggling to find out how the Tasks get added and thought it would be a matter of adjusting a script or calculation. 
      Any ideas?  
    • By Richard Carlton
      Multi-Page Invoices in FileMaker  | FileMaker Pro 15 Videos | FileMaker 15 Training
      Want to know how to make multi-paged invoices in FileMaker?
      Get up to speed with the FileMaker Pro 15 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton.  
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 26 years of FileMaker experience 
      and a long time speaker at FileMaker's Developer
      Conference,Richard will teach you all the ins and outs of building FileMaker Solutions.  The course is 40 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest 
      top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker 
      developers and supporting web designers. He has offices in California, Nevada, and Texas.

      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving 
      FileMaker for Startups and Entrepreneurs, and client server integration.

      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.

      RCC and LearningFileMaker.com are headquartered in Santa Clara, CA.

      Please feel free to contact us at support@rcconsulting.com
      If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store.
      Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      For More Free FileMaker Videos Check out Http://www.filemakerfree.com
      Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training.
      Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There.

      Please Comment, Like & Share All of Our Videos.

      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media

      Filemaker Pro 15 Training Videos
      FileMaker 15 Videos
      Filemaker Pro 15 Video Course
    • By bioplasma
      I would like to start by thanking the developers for such a wonderful solution. Our organization has been successfully adapted FM starting point to our current needs.
      However one of the biggest challenges we have right now comes from having the invoices and Estimates List more than 18 items when they print. I have read in another discussion that was solution for it however I wasn't able to truly grasp the meaning of it. Any help I could get to solve this would be truly appreciated.
      Thank you.
    • By thijswostyn
      I'm having some difficulties with my invoice-system. When having multiple pages on print, I want to have my Trailing Grand Summary on a fixed spot. (not trailing)
      Is there a possibility to have this result? If I would place my fields in the footer, they will show on every page, what is not the intention.
      Have you fixed this one before OR do you have a solution at hand?
      Thanks in advance!

Important Information

By using this site, you agree to our Terms of Use.