Jump to content

Independent Contact Field in Invoices Module


This topic is 2361 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

Tony,

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 [email protected]

 

Thanks,

Jonathan Hogle

Link to comment
Share on other sites

This topic is 2361 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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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