Incrementing a field values based off another field's content.
Hello, I'm currently working on a project where many tables have relationships and require automation features. For instance, if a user selects an option from a lookup field, [Field X], in Table X, then in doing so, [Field Y] will increment in another separate table, Table Y. My design right now is built on a set of reference tables that can be utilized in an operations table. My goal is to "trigger" events such as the one described above to reduce clutter in the operations table. I can provide screenshots and table data/field info if the structure of my app is not sufficiently described. All of the data are just filler to work on functionality. Many thanks, Gabe
Assign Child Record to Parent Record
I'm trying to create an inventory database with my Users as a parent table and my Computers as the child table. Computers need to be assigned to users. I can go to the computer table and easily assign to a user, but I want to be able to go to the user table form and assign an existing computer. This is a Quality Of Life request, to be able to open the form view of the user and then assign existing computers from the computer table and other equipment from subsequent tables. Thanks.
Automatic Form Generation
I have an app with multiple tables for equipment inspections, work orders, and some others. My equipment inspection form includes a variety of multiple choice questions (with Pass or Fail as the options for most), and a "Result" field at the end that displays as Pass if all checks pass, or Fail if any of the checks fail. My goal is to automatically generate a work order (which is another form in the Work Order table that can also be created on its own) in the event that the Result is a Fail when the Daily Inspection is saved. Any thoughts on this? Thank you!
Filter dropdown selection
I want to filter records in a dropdown based on whether a related field is true. Specifically, a project dropdown should only reflect projects with a "funded" status and hide "completed" and "cancelled" Conditional dropdowns doesn't seem to apply, since one reference field is involved.
Question regarding relationships
Hello, I am trying to pull information in from an employee table to auto fill on my form once the employee name is selected. I have successfully pulled in the employee number, employee name, email, phone number, manager ID, and second line manager ID with my first relationship. I am needing to pull additional information back from the table once this information prefills. Specifically, once the manager ID and Second line manager ID prefill, I need it to loop back to the employee table and use those IDs to look up the phone numbers for the manager IDs. (Essentially the phones numbers are only listed by employee, so I would need to take the manager and 2nd manager ID from the first relationship and pull in their phones numbers based on the Employee ID on the employee table) Every time I try to add another relationship to take the Manager ID and look up the phone number, my data pulls back empty. If I delete the secondary relationship, my manager IDs pull back fine. What am I doing wrong!?!? THANK YOU!!!Summarize distinct child records by a text field
I have a parent table (Botruns) that has many children (Line items). The line items could either be processed or not processed and the data for that resides in the line item record in the child table. These line items have an identifier SvcOrderLine# which need not be unique. I know how to summarize the distinct SvcOrderLines in the parent table. But how do I summarize the reasons the distinct lines were not processed when those reasons are captured on the line item record? I was able to create a 'combined text' summary field in the Parent table for 'Reason not processed' but how do I count them now? - Deepa ------------------------------ Deepa Deepa ------------------------------
