Search results

I forgot to apologise, I shoud've known to post all that in the first post! I had hoped that a Eureka moment would come to me while typing all that. It did with a post I was typing yesterday (so I didn't post). Disappointed at brain and google search failure. I just had a meeting and did try...

Example tables below. tblBuilding IDBuild Abb Full 1 B1 Building1 2 B2 Building2tblLocation IDLoc FIDBuild Room 1 1 (B1) 1.1 2 1 (B1) 6.2 3 2 (B2) 4.3tblSWTitle IDSWT Dev Suite Title 1 Microsoft Office...

(This is related to my Are the relationships between my tables *totally* wrong? thread in the Tables forum if anyone wants more background - sorry I can't post links until I hit 10 posts and don't want to spam just to get to that point). Relevent to the problem below is the attached ERD, which...

Hi Dave, Plog was awesome and put me on track with my design - solved the 1:1 kerfuffle. Thanks for the clarification on why not to do it. As for your comment about how the business wants us to handle it, I agree fully. I'm going to present this plan soon, once I figure out the one major...

I was looking at the SME and PoC tables yesterday and wondering about merging them - which I've now done and logically works great. As for Faculty and Building, unfortuantely I can't merge those. Buildings aren't uniquely owned by Faculties. A building for example, can have locations (rooms)...

Oh thank you Plog! I'm sorry I took so long to respond, I was considering the useful info in your response and then pondering overnight the revised plan. This was the moment of clarity. I was just thinking about it from this year with no data in and getting that data in plus next year's...

Hello It's been a good number of years since I've been involved in databases so take me as a newbie. I'm hoping someone will have the Eureka moment that has failed me so far. I'm sorry that this is the 2nd post to the forum, I'm honestly trying not the be rude by jumping in with a HELPME-type...

Hello I’m currently based in the East Midlands, UK and working for an educational establishment. Until fairly recently I hadn’t worked on, or created, databases in anger for about 12 years but I’m now dipping my toes back in the water for a project whose data has been, so far, managed by a...