Attachment 50696 does not display any attachment
Attachment 50696 does not display any attachment
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
The newbie...me...well...considering I haven't touched a database in 25 years newbie.
Oh boy....if you mean the lookup wizard while setting up a field in a table...why yes...that is exactly what I used. I've used them before with success. BUT...on that same token, I am always open to better suggestions.
And there is an attachment called "untitled.pdf". I just tried it and it opened. Not sure what is wonky.
Heck....I rebuilt my entire database because of all the advice I got here. My original question no longer applies. I took that part out.
Mike
Hi Mike
Lookups should not be used at table level.
Ask Google the question "The Evils of Lookup fields in Tables"
You can PM me if you need further help.
Good Reading https://docs.microsoft.com/en-gb/off...on-description
Look at post 16. That is the attachment link we are referring to. Is that your db?
Here's a whole enchilada. I know it's a lot, but you have nothing to lose and much to gain by reviewing all of it.
Normalization Parts I, II, III, IV, and V
http://rogersaccessblog.blogspot.com...on-part-i.html
and/or
http://holowczak.com/database-normalization/
Entity-Relationship Diagramming: Part I, II, III and IV
http://rogersaccessblog.blogspot.com...ng-part-i.html
How do I Create an Application in Microsoft Access?
http://rogersaccessblog.blogspot.com...cation-in.html
Naming conventions
- http://access.mvps.org/access/general/gen0012.htm
- https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
About calculated table fields - http://allenbrowne.com/casu-14.html
About Multi Value Fields - https://www.isladogs.co.uk/multivalu...lds/index.html
Last/First/DLast/DFirst Explained
- https://codekabinett.com/rdumps.php?...ted-result-set
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Oh man....
I'm starting to get a fuzzy feeling in the back of my head now that I might have used comboboxs in my previous databases and not lookup fields....
Would I be correct in that assumption before I go back and start a couple of corrections?
Mike
How could we possibly know that?Would I be correct in that assumption before I go back and start a couple of corrections?
I think you need to research what a lookup field is. The fact that these table fields present combos to "look up" values is irrelevant to using combos on forms. Combos on forms are quite acceptable. People have posted about putting them on reports, but that doesn't seem logical to me - at least I can't recall ever thinking it was a good idea for any report I created.
Last edited by Micron; 08-29-2023 at 10:09 AM. Reason: clarification
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thanks so much for the links Micron!Look at post 16. That is the attachment link we are referring to. Is that your db?
Here's a whole enchilada. I know it's a lot, but you have nothing to lose and much to gain by reviewing all of it.
Naming conventions
- http://access.mvps.org/access/general/gen0012.htm
- https://www.access-programmers.co.uk...d.php?t=225837
What not to use in names
- http://allenbrowne.com/AppIssueBadWord.html
About Auto Numbers
- http://access.mvps.org/access/general/gen0025.htm
The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
Last/First/DLast/DFirst Explained
- https://codekabinett.com/rdumps.php?...ted-result-set
The naming conventions...I had all my tables, forms, queries, named tblImages, frmImages, qryImages (as an example) and that is the naming convention I had used 25 years ago. I had been watching some videos on YouTube by Richard Rost and he used (in my example) ImagesT, ImagesF, ImagesQ. Well...last night, while I was redoing everything, I thought that looked rather nifty and I changed it to that.
I already have my calculated fields in a query and I've simplified that down to an addition field. I did away with my original question that started me on this quest.
I think my relationships are correct and my primary keys are now correct. I think the only table that is using an Auto Number is the Images Table.
I've used DLast/DFirst before in prior databases. I'm going to have to study up on that some more and see where I can integrate it here. It looks like I might need it after giving it a quick glance over.
I'm getting there. Slowly but surely. Stamps 2.0 is a huge improvement over Stamps 1.0.
Mike
Not sure why people prefer the ImagesT format or what is lacking in what we learned 2 or 3 decades ago; maybe it has something to do with how they group in the nav pane. I use the tbl, qry, frm convention since I read left to right. If I used really long names like you were, that's a long read to the end to grasp that it's a table and not a query!
Virtually every table ought to have an autonumber PK. You seem to think that having just 1 is a good thing?
This is getting to be a long thread that has shifted focus, so I'm not sure what Images table now contains. Hopefully just image file paths.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Micron,Not sure why people prefer the ImagesT format or what is lacking in what we learned 2 or 3 decades ago; maybe it has something to do with how they group in the nav pane. I use the tbl, qry, frm convention since I read left to right. If I used really long names like you were, that's a long read to the end to grasp that it's a table and not a query!
Virtually every table ought to have an autonumber PK. You seem to think that having just 1 is a good thing?
This is getting to be a long thread that has shifted focus, so I'm not sure what Images table now contains. Hopefully just image file paths.
I just got schooled by mike60smart. He did a skype chat with me and ran through some stuff that I needed to fix. Yes...I completely misunderstood the Autonumber thing. He showed me how to layout my database better too.
I have my field names shortened...or at least shorter.
And yeah...this thread has shifted focus. The Images table has nothing to do with this thread (and yes...it just contains image file paths). When I mentioned it, it only had to do with using it as an example for my naming convention example change. I've used the frm, qry, rpt for years in the past....I don't know why I changed it...
I get too wordy sometimes. A lot of times.
Unless I get a really tough question, I'll start a new thread. Until then, I have a video saved and I'm starting on Stamps 3.0.
Until later!
Thanks!
Mike
Good luck with your project. Glad I was able to help a bit.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.