ContributionsMost RecentMost LikesSolutionsRe: Edit Record button doesn't work (a=er)Hi Mark, thank you much! That works mostly. Is there a way where it doesn't actually save it until the person hit's Save? Right now it updates the fields, and then uses Edit mode. Which is great, it just doesn't allow a person to make a mistake and back out without saving.Re: Edit Record button doesn't work (a=er)Hi Mark, When pushed, it does go to the record in edit mode yes. When pushed I want to be in Edit mode, so I can enter a quantity (in a qty field) and then save and go back to the record I was on.Edit Record button doesn't work (a=er)Hello, I have a button and when I use ?a=API_EditRecord&rid= it works, but of course saves the record. I would like the record to stay opened in Edit mode. So when I use ?a=er&dfid=2&rid= it doesn't update any of the fields. I need to be able to enter a quantity before I save. I'm starting to feel crazy, but I had the button working the other day fine, and the next day it didn't work. This one updates fields correctly but saves: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & URLEncode([Record ID#]) &_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status & "&_fid_110=1" //Changed Item checkbox & "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status & "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status & "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY & "&z=" & Rurl() This one opens the record in edit mode, but doesn't edit the values of any of the specified fields: URLRoot() & "db/" & Dbid() & "?a=er&dfid=2&rid=" & URLEncode([Record ID#]) & "&_fid_119=" & URLEncode("Change Qty Requested") //Change Order Status & "&_fid_110=1" //Changed Item checkbox & "&_fid_111=" & URLEncode("Waiting on Approval") //Approval Status & "&_fid_109=" & URLEncode("Waiting on Approval") // Change Status & "&_fid_114=" & URLEncode([Qty]) // Change Previous QTY & "&z=" & Rurl() What am I missing here?Pull down that checks data from multiple tablesHi guys, I have an events app that has a lot of tables and while everything is working fine, I'm running into a prob. The tables that come into play here are, Events, Employees, Time Off Requests. In Events, this is the actual events and is linked to mostly every table. In Employees, this is employee details and has checkbox fields for each day of the week (Sun, Mon, etc) where we can specify whether that employee is always unavailable for that day of the week. If all left unchecked, they're available every day of the week. In Time Off Requests, this is of course days the employee has requested off and has approved, unapproved, etc statuses. I'm open to changing some fields or approach here. But ideally what I'd like to happen is: When in an event, a relationship based field looks up the related employee to assign them to an event, but only shows employees that are available (based on days of week off, or time requests approved). For flexibility purpose, I don't mind if when looking up via the related employee field it shows all employees, even if they have off, or not available that day of the week). I know I can filter an employees report, but some of my data I'd like to filter is based in other tables. Is this a possibility or am I reaching here? Any suggestions are much appreciated here and also if there's another way to do this, please let me know. Thank you much! Oliver ------------------------------ Oliver Kenfield ------------------------------