Search results

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...

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...

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!

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...

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. ;)

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...

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.

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

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...

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 ;)

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...

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)...

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?

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

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...

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...

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...

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...

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

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...