Search results

  1. J

    Combo box problems

    Hi! Question: I have Form Project Details that I made for data entry. I based it off of a query that I made off of TblProject Details. TblClientDetails has a one to many relationship with TblProjectDetails (based off of an PK of a name and ID). My question is this: When I view the form in...
  2. J

    Separate Databases?

    Hi All! Thanks for all of the help in the past month or so. I still have a lot of learning to do, but I think that for now, I can actually use the database. My next question is just a general access question. I created a database that has all of our project information in it, and in that...
  3. J

    Combo Box populates every field

    Thanks! What do you mean by where it stores the value? Like I. A table or something?
  4. J

    Combo Box populates every field

    Yes! And I honestly can't figure out how to bind it, or where to bind it. I have a form that I'm using for data entry for our project information. Maybe I'm using the co mBo box wrong, but I thought I could use it to have the data entry person either select a project type from a list, or type...
  5. J

    Combo Box populates every field

    Hi, When I enter a combo box on a form, whatever I choose from the combo box, it populates everything. If I go to a different row to change it, it changes them all. How do I get that to stop? And why does it do that? Thanks!
  6. J

    Build a database

    Thanks, ButtonMoon. That helps alot. Actually, That may change a lot of things for me! This entire database centers around Projects. I kept breaking things up because that's what all the books told me to do. But honestly, this entire database surrounds "Projects." Once the data is entered...
  7. J

    Build a database

    I'm sort of facing the same issue. I have been reading a TON of articles and from an Access book, and it seems like sometimes you can decide to forgo normalization in some case. I have ZERO building experience, so maybe I am misunderstanding. But in my instance, I have a tblProjectDetails...
  8. J

    Bad design to have multiple many to many relationships?

    Thanks! My husband already thinks I"m crazy because I keep trying to logic it out by talking to him, and he has ZERO access experience! Literally every single one of the details/tables that I posted is related to a project. Maybe I"m trying to make this too complicated? Each project will...
  9. J

    Junction Tables

    Oh ok. Thanks! I will definitely check out that sample. Would this process still work the same way if Importing all of the data into Access from Excel? I just read that the easiest way to do that if you're new is to use the wizard, but would I then do these above steps later? or is Access smart...
  10. J

    Junction Tables

    Hi Again! I've have been googling this question for awhile now, and I still can't find a clear answer. When you have junction tables for your many to many relationships, do you put the data into that table? Or just in the two tables that are joined to the junction table? If you don't enter...
  11. J

    Bad design to have multiple many to many relationships?

    Thanks for those suggestions. I will definitely take that into consideration when I actually implement the database. I can see how that would be helpful. Yes, I have MANY fields that will go into this, I just wanted to get them in there so I can have a picture. That was one of the things I...
  12. J

    Bad design to have multiple many to many relationships?

    At last! Please tell me if this makes sense. Thanks!
  13. J

    Bad design to have multiple many to many relationships?

    I did, but I'm having trouble zipping the file. So, we'll see if I get it figured out! I'd love to have a second opinion. I keep talking to people who don't have any access experience, and that's probably not going to help me!
  14. J

    Bad design to have multiple many to many relationships?

    Jdraw, believe it or not I have read all of the tutorials on that site!! I have read so many articles, tutorials, and book chapters. But as this is my first ever foray into access, I'm still very foggy on certain things.
  15. J

    Bad design to have multiple many to many relationships?

    I was going to upload a picture, but I don't see how to do that?
  16. J

    Bad design to have multiple many to many relationships?

    Thanks! I have ultimately split them into the one to many with linking/junction tables. But I am relieved to hear that this will eventually come without much thought. Where I am right now, there is way too much thought going on!!
  17. J

    Bad design to have multiple many to many relationships?

    I haven't entered anything in Access yet, it's all pen and paper. I am on my fourth try on this database, so I didn't want to jump the gun this time. My Many to Many relationships: -Projects can have multiple Employees, and employees can have multiple projects -Projects can have multiple...
  18. J

    Bad design to have multiple many to many relationships?

    Hi All, I'm brand new to Access and this forum, and have been slated to build a database on my company's experience. I'm trying to figure out the correct relationships and table design and I'm having some issues. The way I've broken it down, I have about 8 tables, and 6 of those 8 end up...
Back
Top Bottom