Getting two fill in percentage fields to update totals in a form

[mike60smart]

Attachment 50696 does not display any attachment

[brookbam]

Which one of us is the newbie?
I hope not table lookup fields. Too late to look at your db tonight but your attachment didn't work for me anyway.

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

[mike60smart]

Hi Mike

Lookups should not be used at table level.

Ask Google the question "The Evils of Lookup fields in Tables"

[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.

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

[brookbam]

Hi Mike

Lookups should not be used at table level.

Ask Google the question "The Evils of Lookup fields in Tables"

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

[Micron]

Would I be correct in that assumption before I go back and start a couple of corrections?

How could we possibly know that?

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.

[brookbam]

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

Thanks so much for the links Micron!

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

[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.

[brookbam]

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.

Micron,
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

[Micron]

Good luck with your project. Glad I was able to help a bit.