Recent content by malcolm3000

No. What i'm trying to do is have separate tables feed into one table (I'll call it JoinT). PT (Pressure Transducer) and LT (Level Transmitter) are separate tables that have their TAG fields. Each TAG is unique (there is only one TAG number per part). So later I can use the JoinT to look up...

Mike, Here it is. I've been picking at it when I get the chance. I'm reviewing 'normilization' which is what I think is an approach. I'm also playing with queries but none give me the results I need. ONE TAG to ONE PART (Level or Pressure, etc).. Perhaps I don't need a Joint Table but create a...

Here are the tables, including the JointTable. Notice that the FK for Level, and Pressure have the same ID. I'm trying to get them to have individual IDs. Below, both LTID and PTID all have the same JointTableID.

Mike, Here is a snapshot of the excel file I started with. Note column B has the Tags, TI, PI, LI. These tags have their own tables in access. In access I plan to have other tables for some of the other columns shown. For example (Vendor--not shown below) will be a separate table. The tags...

Tom, yes. that is exactly what i'm trying to do. Earlier in my attempts I was able to add a vendor table, for the parts. But I'm stuck on having all the Partid (TAGS) in one field--JointTable.

DB (thanks for quick responses!), sure, Ill breakdown the equipment as you probably have shown. I haven't gotten that far as far as what you are showing (you can have to FK's--foreign keys in a table?). Here is my first issue I'm trying to overcome, I want the unique TAG (short text) fields...

DBGuy, I'll look into it. But there will be many LIs and PTs in their corresponding tables (it's not for ONE part). LI-1, LI-2, LI-3 etc. and will be located in many places across the plant. The same will happen with the pressure transducers. BTW, here is what I have done, but again, I can't...

hello, new to access and access forum and i'm looking to create a simple database but can't seem to do it correctly. my situation; I want to create a database that has multiple tables for different parts. example, the pressure transducers, level sensors, temperature sensors. all separate...

I'm a mechanical engineer based in atlantic canada and have started my new position as a project engineer. it did not take me long to realize this company needed to have a structured way of tracking parts on their facility plants. do we have any spares? where do we buy them from? where do they...