Search results

We have assets on other facilities that are not within our company.

I'm not keeping up with me, each facility has their own techs. I am just the guy that keeps up with all this. (manager) Yes, the maintenance for these controllers is usually carried out by the assigned facility tech (total of 2), or myself (just me), and in the event no one within the company...

about 25 different locations in 3 different states including offshore oil rigs.

Its deleted...

The synopsis is: A facility can have 20, to 30 controllers [PLC's}. Annually, we upload the active program, saving is with a date/time stamp. This is under normal conditions. If the active program needs to be changed/modified in any way, I will save the active program without changing the...

Here you go. Its the same as before only with your corrections......

Gotcha, I added tblAssignedEmployees and recreated the relationship as seen in your screenshot. In tblFacilities, I changed the datatype of "Assigned Employees" to number to agree with the relationship. With this change, would I be able to enter more than one employee in this field?

I'm giving the table structure and relationships another try on a simple db. I'm pulling my hair out trying to figure this out. Even after reading a lot, I still get confused.... Hope I at least have the structure right.....

Gotcha! That's pretty much what I've read. I truly like the look and functionality of the tab control, maybe I can play with a subform design to make it resemble the tab control. Who am I kidding.....I'm not to that level yet, still figuring out tables! Cheers! -Kyp

Hey gang! I an trying my luck with a tab control within a form. I only have 2 tables, 2 queries, and 1 form. The 2 tables tblEmployees, and tblContractors are almost exact. The 2 queries qryEmployees, and qryContractors are also similar. The form frmPersonnel has a tab control, with 2 tabs...

I’m still here and I haven’t given up!

😡 Okay, I will just need to start over I guess. thanks👍

You’re so awesome!

I agree with what you are saying but, since I have looked over my spreadsheets and reports, the parent asset is what’s described as the main topic of an event, and the child asset would be the cause. Example of a current event report line: EN-873 (facility) PAX-7100 (parent asset) shut down due...

I’m sorry. I went back and reread all the comments from my first and second thread and made me rethink what I’m trying to accomplish. The over all goal it to track assets, and asset events for a couple different purposes. 1. Track the history of an asset. 2. To have the asset info readily...

Also, I just realized that facilities often have and asset with the same asset name, but different facility. I was also thinking about another scenario. In the asset table, the asset number PT-2100 is a pressure transmitter that resides on a pump. The pump would be the parent asset of PT-2100...

Oof I am sorry, I did not realize. thanks for letting me know!

Yes sir. I downloaded the sample you provided and studying it. I’m sure I will have question….

Yes, an event will only have one asset.

Guys, I just want to express my appreciation to you all. Please do not hesitate to correct me when I am wrong. I do not understand everything you guys are saying and have to look up the lingo, lol. Just saying I appreciate you guys taking your time to help and educate me on this thing...