Search results

  1. N

    Many to Many (junction) data entry via forms

    Sorry, not sure I was clear in the original post. I already have a Requirements form from where I can select the Locations that ONE SW item needs to go in. Not a problem because the Locations table is static, so I just pick which rooms I want to associate to that Requirement (via a cbo) and the...
  2. N

    Many to Many (junction) data entry via forms

    My database has a few many to many relationships that are resolved with junction tables. I'm now building the forms. I have no problem on forms making the associations between records via the junction table if both sides of the M:M have records, but I can't figure out how to do the following...
  3. N

    Spreadsheet Style Report? Column and Row headers

    I've just found that after doing the work in Excel using pivot. I then hit on Cross tab in a search and https://blogs.office.com/2012/05/23/using-crosstab-queries-in-reports/ Hurruh. Why is it I google and google and get nowhere. Post a question and then find the answer!
  4. N

    Spreadsheet Style Report? Column and Row headers

    Someone has asked me today to manipluate some data on a worksheet (from one of many spreadsheets the database I'm currently trying to create will be replacing) for a report. The data is not normalised in any way (so one massive worksheet). I've quickly imported the data and tried to split it...
  5. N

    Is this type of functionality done at form level, not table?

    It really, really does. Thank you. I had a moment of clarity yesterday evening as a result of it. Thank you! I now have another relationships query, but that's a seperate post. ;)
  6. N

    Is this type of functionality done at form level, not table?

    Hi MarkK, I've been revisiting your separation of Request and Installs idea, but I'm trying to define the relationship and cardinality. Originally I had this below and couldn't wrap my head round it: A request (for a software item in a location) will result on none or one Install (in that...
  7. N

    Is this type of functionality done at form level, not table?

    but a Request is for 1 SW item in 1 Location, a request can't have many installs as I'm not tracking by workstation within a location. It's still 1-to-1. Installs is just the Request but with an association to package, which still leaves me with the original problem.
  8. N

    Is this type of functionality done at form level, not table?

    Can anyone respond the original query? Is this possible to do? Or only at form level? Thanks
  9. N

    Is this type of functionality done at form level, not table?

    Developer: the software developer of titles (i.e Microsoft, Adobe) SWTitle: Title of the software (i.e Word), excludes version or platform info. Includes optional suite information (i.e, Office) SWVersion: A specific version of a software title (2016, Windows / 2016 Mac). Details version...
  10. N

    Is this type of functionality done at form level, not table?

    Also, I'm still a little uncertain of the 1:1 between Request / Installl. I thought they were the devil's work and must be avoided ;)
  11. N

    Is this type of functionality done at form level, not table?

    Ok, I've attached my (reduced for clarity) ERD (see ERD-tblPackage-REDUCED.PNG) I've also attached a diagram of what was suggested by MarkK (ERD-suggested-1to1.PNG) but with the addition of the link between Request and SW version. I must have a direct link from Request to SWVersion. A package...
  12. N

    Is this type of functionality done at form level, not table?

    I guess if there is an entry in FIDPackage in tblInstalls for a record, that indicates the request was successful and a install made. I've just spent an hour or so trying to rework the ERD and just can't make it work, because I understand logically where you are coming from. If (old)...
  13. N

    Is this type of functionality done at form level, not table?

    Yep, a request becomes an install - it'd be a 1:1 or 1:None between REQUEST and INSTALL if I had to separate them out. Therefore rather than having a 1:1 which I understand is not good practice, we'll just delete a entry if it doesn't become a actual install. Does that sound wrong?
  14. N

    Is this type of functionality done at form level, not table?

    Which is why there is still a link direct from tblInstalls to tblSWVersion.
  15. N

    Is this type of functionality done at form level, not table?

    I work for an educational establishment and the database, of which listed above, is part of it. It tracks software requested for each room (location). Perhaps if I'd included tblocations it would've been clearer. tblLocations 1:M tblInstalls M:1 tblSWVersion (tblInstalls resolves the software...
  16. N

    Is this type of functionality done at form level, not table?

    Can someone point me in the right direction. I have the following relationships between 3 tables: tblSWVersion 1:M tblInstalls tblSWVersion 1:M tblPackage 1:M tblInstalls The table's fields are as follows, with example data: tblSWVersionIDSWVersion SWV1 SWV2 SWV3tblPackageIDPackage...
  17. N

    Query two records on same table, and output based on results

    This works PERFECTLY!!!!! Plog, you are a genius! GENIUS! I'm now going to spend time picking it apart so I can fully understand the logic. My main problem was that I wasn't thinking about it from pulling out data into subqueries, but trying to do it all in just one. If anyone else is reading...
  18. N

    Query two records on same table, and output based on results

    Plog, thank you!!! I will check this out tomorrow and report back (although I'm acting as a Team Leader tomorrow due to a short straw scenario, so actual work on DB may not happen until Sat). I'll pick it to pieces to so I understand what's going on too :D I feel a thank you isn't going to...
  19. N

    Query two records on same table, and output based on results

    Only one year look back. If it's not there in 2016, it's not installed, the change for 2017 will be 'new install'.
  20. N

    Query two records on same table, and output based on results

    Correct. But now else will it know to match, for example, tblInstalls Record 1 to Record 2 by not including these tables? I'm confused at how you do that (I suspect I'm going to feel really stupid when you tell me). Yes. The parenthesis are showing the parent table data. You bring to mind many...
Back
Top Bottom