DavidLessin
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Report link on new forms - create new record
I was literally trying to accomplish the same thing and had just decided to reach out to the forum. Easy to do when the tables are in the in same application, but I am having trouble creating a cross-application related record. If I create a related record in the cross-related application it does show up as expected in a list box, but it would be quite convenient to create the related record from the parent record which resides in a different application (but within the realm). As one can see from button Add Currency Exchange (Test), I am not mapping correctly to the related app Thanks! David Lessin Director +1 312 909 2721 mobile Information Services Group is a leading global technology research and advisory firm. Confidentiality note: The above email contains information that is confidential and/or privileged. The information is for the use of the individual or entity originally intended. If you are not the intended recipient, please contact the sender and delete the material from any computer. Please be aware that any disclosure, copying, distribution or use of this information is prohibited. Please consider the environment before printing this email or attachment.Re: How to display a thumbnail image on a table report
SLMPAC Development, Having spent over two hours on this in the past (deleting, replacing files, testing, blahh.). The 5 second fix is to clear your browsers cache! I included a screenshot of the formula field I used to display the attached file in a report (in this case, a country's flag). David Lessin Director +1 312 909 2721 mobile Information Services Group is a leading global technology research and advisory firm. Confidentiality note: The above email contains information that is confidential and/or privileged. The information is for the use of the individual or entity originally intended. If you are not the intended recipient, please contact the sender and delete the material from any computer. Please be aware that any disclosure, copying, distribution or use of this information is prohibited. Please consider the environment before printing this email or attachment.Re: How to use GenAddRecordForm and update the child record's multiple fields using data from the parent record
Thank you Mark! Lining up the _Fid_ was an extremely helpful suggestion, which allowed me to focus on misplaced "! This is what I ended up with, and I have at least a dozen other action buttons that an use similar treatment, so I will get plenty of practice! URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm" & "&_fid_9 =" & URLEncode ([Client (Related)]) & "&_fid_11 =" & URLEncode ([Project (Related)]) & "&_fid_21 =" & URLEncode ([WAN-Xchange Loc ID]) & "&z =" & Rurl() ------------------------------ David Lessin ------------------------------Re: How to use GenAddRecordForm and update the child record's multiple fields using data from the parent record
Thanks Mark... I am very familiar with relationships, but the business is pretty dynamic and we get numerous quotes that for the same sites. In fact the bid ID will change, but in the case, I just to see how to update the fields. In the long tern, I will update the relationship so only 1 field will vary (bids). ------------------------------ David Lessin ------------------------------How to use GenAddRecordForm and update the child record's multiple fields using data from the parent record
I am trying to add a related record and update the URL code to include updates to the child record with data from one more than one field on the parent record. I have been unable to find any code examples and after several attempts, and not knowing for sure if this is even possible, I find that I need to ask for help! I thought this would be simple (old school SQL guy) but I keep failing. Really appreciate a hand! Original Code: URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])& "&z=" & Rurl() From the parent record, I want to include: [Client (Related)] into to child record field ID 9 [Project (Related)] into to child record field ID 11 [Bid (Related)] into the child record field ID 15 URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])&_fid_11 =& URLEncode [Client (Related)]& "&z=" & Rurl() ------------------------------ David Lessin ------------------------------
