Search results

Thank you everyone for your help. I think I'm finally to the point where I can start asking more specific questions and will do so in new threads.

If I'm understanding this correctly, the data for the list lives in a table and you're using SQL to pull a piece of this data out at the time the user makes the selection using the lookup. None of its fields are tied to another table as a FK. And since the data lives in a table, a Form can be...

My new (and hopefully improved database) is attached along with a picture of the relationships window. tblCheckItems is currently not related to any other tables. I'm not sure where I should relate it. I was initially going to relate it to tblEquipment but we typically have at least one...

No, I would not. However, I want the user to be able to add types to the list in case the type they need is not currently in there. But I do not want them to be able to edit the types that are already there. It's funny you mention sub-types as I was planning on setting that up as well. I am...

I believe I have an understanding of both approaches. The approach used just depends on personal preference and whether or not I plan to scale out to a larger DBMS (database management system?). While I appreciate using the combo box would be easier to initially setup and would result in...

My plan was to have a list box in the higher table (tblEquipment) have it point to the lower table (tblEqType, tblEqMfr) as its row source. This will prevent a user from misspelling one of these items and I can also have a form that will allow a user to Add a manufacturer/equipment type if need...

What exactly does this mean? Did I do something wrong to trigger this?

Ah. Completely understandable!

ATM, my flow rate table has a PK, (3) FKs, and a number entry. (see attached screenshot) I would agree with your statement if any piece of equipment would only have (1) flow rate. However, some of the more complex units can have more than (10) different flow rates associated with it. (When...

Would it be overkill to have a table for FlowRateUnit and and relate it to the FlowRate Table with a FK?

Thanks. I'm definitely not the greatest at stepping back and looking at the data from a larger-picture-POV. The only thing I don't get is this part. How would a negative number achieve this?

Thank you for education me on proper etiquette. I will update all my posts with the necessary information. And I was worried about the broadness of my question, but I felt like I was :banghead: enough that I had nothing to lose. I take it after I make adjustments and figure out how to limit...

Welcome! With knowing so many different languages, do you find that new languages are easier to learn once you had one or two under your belt?

HVAC -> Heating, Ventilation, and Air Conditioning. I just realized that may have been what you were asking about, not the PE part.

PE stands for Professional Engineer. Simply having a degree doesn't earn you the title. Requirements vary from state to state. Where I'm at, you must have a 4-year BS or graduate degree from an ABET accredited school in an engineering field, have at least (6) years of experience, have letters...

A little about myself: Married No kids 4 cats Engineer in the HVAC Industry (Hopefully soon to the be a PE) Love video games on PC and Nintendo I'm here to learn Access to make my job easier and to help the company run more efficient. Everything we do right now is in either Word or Excel...

Edit: I have been enlightened on the proper etiquette of cross-posting across multiple forums. I have also posted this question in the following places on Reddit/r/MSAccess and at UtterAccess. I can't post links yet because I haven't reached 10 posts but will add them as soon as I am able...