Search results

  1. P

    Form/Subform Linked Fields w/Join Table on 2 Fields

    I'm following the logic and implementing now to test it out. Looks like when I add the second calculated field it's asking for the Parameter "Both_IDs". If I remove the criteria the Parameter pop-up goes away. Naming appears to not be an issue. Do I need a 2-step query to handle this?
  2. P

    Form/Subform Linked Fields w/Join Table on 2 Fields

    Yeah that's the issue. I've got a lot more at play that what I'm posting, but trying to just keep the relevant bits to the conversation. I've actually got a TaskTreeID and ParentID in tblTask as well because all of the Tasks fall underneath of a particular Task Tree in which they are only...
  3. P

    Form/Subform Linked Fields w/Join Table on 2 Fields

    Here is a simplified diagram of what I've got. Big picture is that I've got multiple Tasks in the tblTask that I'm building relationships to themselves in a many-to-many amongst themselves. Tasks could be parents to multiple other tasks and also children to multiple other tasks. The Join table...
  4. P

    Form/Subform Linked Fields w/Join Table on 2 Fields

    I have a form that summarizes tasks and contains a subform that displays relationships that are created between 2 Tasks via a Join Table. The Join table has a ParentTask and ChildTask field. I want to link the subform to the parent form via the Linked Fields functionality. My issue is that...
  5. P

    How best to handle multi-step insertions on multiple 1 to Many Tables

    I don't think I'm looking at a nested form approach. Anytime the 6 entities can be related, they are always in a many to many relationships so I have join tables for every instance where they can be related. I'm just trying to think through a neat and nice way of allowing the user to start at...
  6. P

    How best to handle multi-step insertions on multiple 1 to Many Tables

    That is an extremely valid point and something I will have to consider. The interface is intended to be used with existing records, and just to create an entry in a join table to create the relationship. The idea then was while we were going through a multi-step wizard to build the...
  7. P

    How best to handle multi-step insertions on multiple 1 to Many Tables

    Absolutely. Did this and the model support the business rules ... now it's just trying to streamline the interface to make it as easy and user friendly as possible.
  8. P

    How best to handle multi-step insertions on multiple 1 to Many Tables

    I know it sounds wrong, but I'm pretty confident in the normalization of the design. The issue is that the data for the project is fairly complicated with a lot of messy relationships that can exist. Lots of many-to-many relationships that I need to capture, but the business rules of the...
  9. P

    How best to handle multi-step insertions on multiple 1 to Many Tables

    Good Afternoon All, Working on an app that has 6 major data types. Plans, Categories, Requirements, Solutions, Programs, and Vehicles. I have a plethora of 1 to Many tables that capture the relationships between these major types of data. What I'm trying to do next is build a multi-step form...
  10. P

    Handling Imported Data

    Great advice. I was working through the bloat issue and landed on a separate "Import" FE that would handle all import/appends, etc. via local tables before pushing ultimate changes to the BE. This is a good idea on the approach that I might consider / shift to.
  11. P

    Handling Imported Data

    That's my workflow as well. Since I'll be importing data and managing changes to it on a daily basis, wasn't sure if a best practice was to keep the imported data in a separate table, then union it for use, or import it to a permanent structure and have a field to reference that it will ID'd as...
  12. P

    Handling Imported Data

    That's exactly what I was looking at. Merge into a common table with a key back to the UID for the data or Union two tables with a possible additional table for a Master PK to reference.
  13. P

    Handling Imported Data

    Good Afternoon, I've got a DB that will require importing JSON and CSV data on a recurring basis. I will need to deal with additions, deletions, and modifications to the data every time I import it to make decisions based on how the currently imported data is being used. Is is a better...
  14. P

    Controls to Sort Continuous Form Records with an Integer Priority Field

    I can get on board with that. Does that solve any of my multi-user possible issues?
  15. P

    Controls to Sort Continuous Form Records with an Integer Priority Field

    Thanks all. I typically try and avoid Listbox's (personal preference) but not opposed. Help me understand if there is a better way of doing this. I was wanting to have them sorted in real-time just from the usability perspective (easier to see how you have something ranked if it shows in order)...
  16. P

    Controls to Sort Continuous Form Records with an Integer Priority Field

    Good Evening, Im trying to take a list of records that are displayed on a continuous form and have a control on each record that allows me to “promote” and “demote” each item on the list. Im basically wanting to allow the user to place each record in a priority order of their choosing. I’ve got...
  17. P

    Create Record in 2nd Table when Record Added in First Table (Conditionally)

    Good Evening, I have a form called "SystemDetailModal" that is bound to a table, "tblSystem". I have a continuous subform that is bound to "tblEvent" and it allows for Events to be added in connection to it's respective System (parent form), but those Events need to be assigned to a...
  18. P

    Totals Query Help (I Think ...)

    Access Gurus, I have two tables that contain the data I need. Tables Results Gotchas: -(Order) is the sequence in which the steps (PRStepID) progress sequentially End Goal: Return the (PRStepID) with the Lowest (Order) grouped on the (ReportID) Where the (CompletedDate) Is null. If...
  19. P

    Rectangle.HorizontalAnchor Property Issues

    Thanks, I'll take a look at it.
  20. P

    Rectangle.HorizontalAnchor Property Issues

    I double and tripled checked. Attached is a screenshot of the form. I tried setting the object variable, and it still is telling me there is an invalid reference. I've got this in the onFormat event of the Detail section of the form if that has anything to do with it. Any other ideas?
Top Bottom