ContributionsMost RecentMost LikesSolutionsRe: Field not showing up in Dynamic Filter That fixed it. Thanks! This email and any attachments were sent from a Remington Seeds email account and may contain confidential and/or privileged information. If you are not the intended recipient, please contact the sender and delete this email and any attachments immediately. Any unauthorized use, including disclosing, printing, storing, copying or distributing this email, is prohibited. All emails and attachments sent to or from Remington email accounts may be subject to monitoring, reading, and archiving by Remington, including its affiliates and subsidiaries, as permitted by applicable law. Thank you. ------Original Message------ Numeric fields cannot be used as dynamic filters. Try switching the field type to text. ------------------------------ Adam Keever ------------------------------ Field not showing up in Dynamic FilterI have a Year numeric field that I cannot get to show up as an option to add as a Dynamic Filter on reports. See attached screen shorts. Am I missing a setting? ------------------------------ Brad Dixon ------------------------------ Re: Order to Line Items Process Found the check box and that solved the problem. Voted for the enhancement too. Thanks for the quick help! This email and any attachments were sent from a Remington Seeds email account and may contain confidential and/or privileged information. If you are not the intended recipient, please contact the sender and delete this email and any attachments immediately. Any unauthorized use, including disclosing, printing, storing, copying or distributing this email, is prohibited. All emails and attachments sent to or from Remington email accounts may be subject to monitoring, reading, and archiving by Remington, including its affiliates and subsidiaries, as permitted by applicable law. Thank you. ------Original Message------ There are four solutions here. 1. Enable the checkbox in Advanced Properties to save Parent Automatically when a child record is created. 2. Read this thread herewhich says the same thing in the form of a very long rant :). 3. Vote for this enhancement here 4. Note that you can indeed enter child record on an unsaved parent record when the child table in open for editing in grid edit mode and the children will get connected to the parent upon saving the parent, so Grid Edit data entry of children is another option. ------------------------------ Mark Shnier (YQC) Quick Base Solution Provider Your Quick Base Coach http://QuickBaseCoach.com markshnier2@gmail.com ------------------------------ Order to Line Items ProcessI have an app where the user creates an order and there is another table for the order line items. Currently, when entering the order on a form the user has to select "Save and Keep Working" to save the order before adding the individual line items. Is there a better way to do this? There is an Add Product button on the form where the user enters the line item information. Could something be added to that button to make it save the order first automatically? Here is the current URL for the Add product button. URLRoot() & "db/" & [_DBID_LINE_ITEMS] & "?a=API_GenAddRecordForm&_fid_13=" & URLEncode ([Record ID#])& "&z=" & Rurl() Order form example attached. ------------------------------ Brad Dixon ------------------------------