Hi there, I am very simply trying to copy a number of cells from excel to access and whenever I try to do this the cells are added in access but they come up blank. I'm using the special paste append option in access but it's still not working. any idea why all the data pasted from excel would...
Hi again, Maj. The other table is 9 options and it's creating problems in my split form and in my subforms, so I just want to get rid of the number representation of those 9 options and just simplify with the actual values. I know I could do an update query to change those ID numbers to the...
I was storing FK ID's in a field in a table, but would like to replace those with the actual values. What is this best way to accomplish this? Thank you :)
Anddddddd, in reading on in the links, I answered my own question, you have to go with the scenario that has the biggest values for the left and right of what you're considering. So "many customers can transact many sales" is the right way to set up the relationship.
As I think about things, I guess I'm a little confused by something else. In looking at a relationship between customers and sales, when do I conclude :"one customer can transact one sale at a time" vs. "many customers can transact many sales." The main difference here seems to be time period...
Ok from your reading all of your wonderful links, I see what I was getting confused between say "sales" and "customers." And entities and entity types.
How you phrase the question matters - A LOT. For example in trying to establish the cardinality (new word I learned, thank you very much!)...
Hi there, I'm trying to really understand one to many versus many to many, because it's really messing up my database designs I'm pretty sure. To take a common example, courses and instructors. To me, this could BOTH be, one to many and many to many. A course could be taught many instructors...
Wow, I cannot thank you enough for this. I'm really floored by the generosity of this community, and that people go to these lengths to help others. I know this was a lot of work and I'm extremely grateful! I'm sorry about the delay in replying, dealing with sick family members and trying to...
That would be amazing :)
Oh my god! Thank you!!!!! That's EXACTLY what i'm looking for!!! can you share your table structure, and did you have to do a ton of code?
yes, just one person, so no person was actually going to be in the database
i didn't want to have individual dates associated with each task, avoiding entering in the date over and over
was trying to avoid rows and rows of duplicate data (so much of this stuff seems to be a judgement call...
Looks like the problem is going to be the form. :( Regardless of how the table data is structured, representing it on the form is going to be the hiccup, since one checkbox apparently equals one field and there's no way around that.
Thank you so much for taking the time and effort to write all of that up! Here's what I have:
tblCompletionDates
-CompletionDateID
-CompletionDate
TblTask_CompletionDates
-taskID (PK)
-CompletionID (PK)
TblTasks
-taskID (PK)
-Task
TblLevels (not relevant to the problem)
tblHabitCategories...