EricFixler1
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
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 ------------------------------Add Record -POPUP Window size
What 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 ------------------------------Child 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 ------------------------------
