ContributionsMost RecentMost LikesSolutionsRe: Conditional Dropdown to MultiSelect Thanks The solution works. ------------------------------ Eric Fixler EFC ------------------------------ Re: URL Formula, "mailto:" & Thank you. I will give this a try. ------------------------------ Eric Fixler EFC ------------------------------ Re: URL Formula, "mailto:" & That sounds useful. Can you share the code? ------------------------------ Eric Fixler EFC ------------------------------ Re: Conditional Dropdown to MultiSelect Thank you, Are you suggesting that I recreate the original relationship multiple times? How then do I force the lookup to Type be consistent in the secondary relationship? I need the type to be a single entry and that is used in the first and second relationship. ------------------------------ Eric Fixler EFC ------------------------------ Conditional Dropdown to MultiSelect I am trying to setup a structure where you have a Co-Name, Type and Subtype (3 connected tables) I have the relationships setup where the following works. Each co has one type each type can have one subtype Subtypes are conditional on the type selected. Is there a method to allow the subtypes to be a multiselect option? I would prefer to have each of thes in a separate table for ease of management of the data Thank you. ------------------------------ Eric Fixler ------------------------------ Re: Add Record -POPUP Window sizeThanks for the help. Works perfectly. Eric ------------------------------ Eric Fixler ------------------------------ Add Record -POPUP Window sizeWhat would be the correct syntax to add to this formula to designate the dimensions of the popup window ? URLRoot() & "db/" & [_DBID_CONTACTS] & "?a=API_GenAddRecordForm&_fid_12=" & URLEncode ([Record ID# - Company])& "&z=" & Rurl() ------------------------------ Eric Fixler ------------------------------ SolvedChild to Parent Record Update Child to Parent Copy In this example I am focussing on two tables Company and Contacts Some contacts have the related company as TBD and that causes issues in reports on other related tables. I need to change all TBD companies to a combined field of "Last Name" & " First Name" & "TBD" and then have the child record be related to the parent record ID so I can report on it correctly. I created a TBD Formula field that creates the correct company name but I don't know how to create new companies and relate the existing child records to the new company ID. ------------------------------ Eric Fixler ------------------------------ Re: Month between 2 dates calculation(((12*Year([Maturity Date]))+Month([Maturity Date]))-((12*Year([Origination Date]))+Month([Origination Date]))) This seems to accomplish the correct output also. Thanks. ------------------------------ Eric Fixler ------------------------------ Re: Month between 2 dates calculationMark; This look good, but provides me the Term in years. How would you suggest I convert that to months? ------------------------------ Eric Fixler ------------------------------