Search results

Access noob, subform help. Error msgs, not allowing edits, & not updating fields...? I'm working on a home movies database and created a form (MovieDetails) that should allow the user to either edit existing movie information, or add new movies to the database, but the subform is giving me...

That got it working, thanks m8! :D

Thanks for the suggestion, I'll try that. Does my DB appear to be normalized to at least 3NF? Or could it use improvements?

As the title states, i'm still a noob at Access. I'm trying to build a database with which I can keep track of my home movie collection, track loaned and returned movies, and help to eliminate duplicate movies (in case I've already entered a movie, then later buy it again, and enter it a second...

Well said, understood, and 100% agree. In my studies of normalization thus far I have come to the realization that, in a real-world situation such as this, adding an additional PK field (such as an autonumber) would be the best thing to do. Rest assured, once I am done with this class I will...

Hi, just one more question... I wanted to make sure I'm putting the correct fields in the Clients table to meet 3NF requirements and am questioning the "Billed" and "Paid" fields. Originally I had them in a seperate Billing table, but after thinking about it and after seeing some other examples...

I just got wind of my Final project. It will be to create a full DB for a fictitious video store. It will consist of forms, reports, and most likely need to be in 3NF. Since I am a "movie buff" it should be a fun project. I'll definately be asking more questions on the near future. For now, I...

Thanks Bob. I realize now that his instruction may be strange, but there really isnt anything I can do but do what he requires... at least until I pass the class (I've got 100% so far... so even if I get docked a little on this one, it shouldnt hurt me too much). Thanks for helping me...

My instructor also said "You don't really need to add any additional fields to solve this." So I'm wondering if I'm going about the CustomerContacts table wrong? I just dont see any other way of assigning a PK to this table other than making a composite key with the CustomerNumber and either...

I understand it sounds strange or confusing. Please allow me to explain. It's not that I am not allowed to design it properly, it is a learning assignment focused on teaching only the concept of normalization by using a fictional database not ever intended to be used in a real-life situation...

Rite, but in my response to Banana I clarified by saying: Although I appreciate you taking the time to respond to my post, your responses dont really provide a solution in my case...

Well, here's my specific situation. I have a table, and the part in question is structured like so: tblClients (ClientNumber, ClientName, ClientType) tblClientContacts (ClientNumber, Phone, FirstName, LastName) The ClientNumber in tblClients is the PK, and I need to join it to...

Okay, thanks again. By the way, Buckaroo Banzai is one of my favorite movies too :D

Does every table in a 3NF DB have to have a PK? I'm an access noob, still learning, please bare with me. When building a database in Third Normal Form, does every table in the DB have to have a primary or composite key? Can a table just have a Foreign key and no Primary key? I should know...

Good suggestion, I may do that. I have a friend that is a DB designer and is quizzing me on this DB I made. He's asking me to solve certain problems to help me learn. But he will not give me the answers lol! He wont even answer my questions, so I have search the web for nice places like this...

Awesome BigBooty, thanks a ton! :D That helps clarify a few things. I'm curious how you (or anyone) would handle this next situation; I have the two following tables: tblTechs (TechNumber, LastName, FirstName, TechLevel) tblTechRates (TechLevel, TechRate) The billing rates for all Techs may...

Okay, thanks Rabbie. Another question; For a table to be in 3NF, does every table in the DB have to have a primary or composite key? I should know this, but for some reason my brain isnt working at the moment... My question arises from wondering if I can simply join the Clients and...

I have another question; Is there any way of converting the original, un-normalized table (see first post for DB attachment) into Third Normal Form without adding any additional fields to the resulting tables? Or is it absolutely necessary to add additional fields to achieve 3NF?

I really appreciate you guys taking the time to help me learn more about normalization. I understand that the table, if it were to be used in a real-life situation, would need the modifications BigBooty described. My focus, however, is not on the longevity of the database, nor on its potential...

Can you explain why (cuz i'm still a noob lol)? Would this be considered an example of 3NF? Or would the example you provided be higher than 3NF? I'm just trying to get a clear understanding of how this table would look when in 3NF form. Yes, I was unsure how to handle the tblClientContact...