norburao01
Registered User.
- Local time
- Today, 14:33
- Joined
- Jul 16, 2019
- Messages
- 12
[Solved] Issue with Relationships (I think)
Hi all,
I'm a new user to access and this forum so sorry if I don't understand reply's straight away.
I am looking to do something quite specific and couldn't found any help online and wondering if you guys could help me.
I am building a database to track interfaces between components on a project I am working on, as such I've got a table full of data on the specific components (called component data).
I have made a separate table to track the interfaces (called the interface table), with two columns referencing the unique ID numbers of the two components that are connected together from the component data table.
The problem is when I come to make a form to pull up a specific component I want to be able to see all the connections that that component has, but unfortunately it only shows the connections that I reference first (in the relationships tab). Please see the pictures as I haven't explained that too well. I want to be able to see connection 4 to 3 on component 4 like it is on component 3's form.
This probably comes down to the issue that in the relationships tab, connecting two unique ID's from one table to two coulombs of another table it creates a copy of the first table.
Any help on how to solve this would be greatly appreciated as I'm stumped.
Thanks
Hi all,
I'm a new user to access and this forum so sorry if I don't understand reply's straight away.
I am looking to do something quite specific and couldn't found any help online and wondering if you guys could help me.
I am building a database to track interfaces between components on a project I am working on, as such I've got a table full of data on the specific components (called component data).
I have made a separate table to track the interfaces (called the interface table), with two columns referencing the unique ID numbers of the two components that are connected together from the component data table.
The problem is when I come to make a form to pull up a specific component I want to be able to see all the connections that that component has, but unfortunately it only shows the connections that I reference first (in the relationships tab). Please see the pictures as I haven't explained that too well. I want to be able to see connection 4 to 3 on component 4 like it is on component 3's form.
This probably comes down to the issue that in the relationships tab, connecting two unique ID's from one table to two coulombs of another table it creates a copy of the first table.
Any help on how to solve this would be greatly appreciated as I'm stumped.
Thanks
Attachments
Last edited: