Interninneed
New member
- Local time
- Today, 17:00
- Joined
- Jul 21, 2021
- Messages
- 6
I am sorry if my title makes little sense, I am learning Access as I go and I do not have all of the vocabulary. I will try to explain but I think the pictures I have will work better.
I am trying to show that two pieces of equipment are connected by the same conduit/wire (see drawn pic).
I need to be able to :
-Input the two pieces of equipment and the conduit at the same time (from combo boxes from connected already populated tables)
ex. [equip 99 ]-[conduit 1002]-[equip100]
-Create a query that shows all of the equipment and their connected equipment.
-Create a report that shows all of the equipment, its information, and the connected equipment and its information.
Issues:
-Creating a to/from field does not allow all of the equipment to be displayed at the same time. ex I can only show the to but not the from on a report.
I am not afraid to use code if needed. I know I showed pics from excel but It was the best way I could think of showing what I wanted.
I am trying to show that two pieces of equipment are connected by the same conduit/wire (see drawn pic).
I need to be able to :
-Input the two pieces of equipment and the conduit at the same time (from combo boxes from connected already populated tables)
ex. [equip 99 ]-[conduit 1002]-[equip100]
-Create a query that shows all of the equipment and their connected equipment.
-Create a report that shows all of the equipment, its information, and the connected equipment and its information.
Issues:
-Creating a to/from field does not allow all of the equipment to be displayed at the same time. ex I can only show the to but not the from on a report.
I am not afraid to use code if needed. I know I showed pics from excel but It was the best way I could think of showing what I wanted.