Search results

I have down loaded your attachment and it seems that it would be easier to maintain all the data. Not sure I understand it all, but I'm trying!

An event would be tied to only one asset while an asset can have multiple events (over time). With that being said, I need to read up on relationships. I will reverse it. I only did this as to not confuse myself. Opening the DS I do see what you are saying. I will fix this. I kind of...

I understood that the table was not optimal but I don't know what or how to optimize the master lookup table. I am striving to create this correctly so if you don't mind, please explain. I did not understand the comment on the revision. Understood, I will make that change. I have read that...

I've just downloaded it and will start on it now. Thanks! -Kyp 73 Thank you ma'am, and sorry about the confusion!

I've changed a few things up and added a couple records in each table. I am not sure how to split up tblMasterLookup to make it correct. Splitting the table into multiple tables was what I originally had but seems like too many tables. I may just be overthinking it? I haven't figured out (yet...

I did not notice that until you called it to my attention. I have removed the "0" as well as set the fields to requires = Yes and allow zero length = No ( no one said to do this, I was just thinking this should be the case) I think I have misunderstood an earlier comment stating that I could...

I've taken all the info that I have understood and created the tables. I also created the relationships, don't know if they are correct but I tried. Tried creating a form and putting in some dummy data but getting errors. "You cannot add or change a record because a related record is required"...

Aha, I see what you are saying now. Being that a report will be generated daily pertaining to open and closed events. Somehow, other than someone looking at dates or other info, the report query will have to know the event status. Also, the plan is to enable record locks. When an event is...

You are correct, but not 100% sure I understand. What I think I'm understanding is that the facility "field" doesn't need to be in the tblEvent but, the facility would be part of the asset record therefore, when the AssetID is polled, the facility information would follow? I see what you are...

Understood. An event will always occur at a facility. When creating an event, the facility will need to be identified. Should I still remove facility from the event table? Not trying to negate you’re advice, just trying to learn and understand things as I venture into this unknown world! I...

Gotcha. I will remove any special characters to avoid future issues. Thanks!

I’ve read somewhere, when multiple users would be in the db at the same time, setting the autonumber to random would lessen the possibility of a conflict. (This will eventually be a split db. FE/BE) The AssetID would be the autonumber assigned to the asset while the AssetNumber is a...

Gents, After ready lots and lots of info provided by you guys, I've laid out my data tables in an excel spreadsheet, a different sheet for each table. I hope you guys don't mind taking a look and let me know if I am on the right track here. I haven't put anything in access yet, just preliminary...

I've read over the info you guys shared and very informative to say the least. o_O Some things are understandable while others are a little over my head at this point. I'm building a DB for 2 reasons. 1. To learn the fundamentals of relational database as I truly enjoy it! 2. To help myself...

Thanks guys for all the info. I am reading over all the links now. Cheers! -Kyp

Hello gang😊 I have started an access project and after searching the forum, I have a couple questions on table structure. Questions: I've read in several threads that I should NOT use any type of "Lookup" in a table structure. No "Combo Boxes", or "Value List", period. I understand but why...

Hey guys, I am starting an access project and I’m sure than I’m going to have questions! I do know how to use the search function and will do my best to search the threads before posting a question. Cheers! -Kyp