I don't think you are being dim. The difficulty in trying to respond to any request is to get the gist of the problem, and the context in order to offer some suggestions. From your posts I got table and columns, then nodes and coordinates, then some desired output format that looks like a spreadsheet. on rereading, I see Links (which has a different meaning in Access context) -
From coordinates, I think Points. You said the coordinates represent Nodes, so there are Nodes.
From Links, I am getting Network or Network segment.
So in database terms--
Consider building /describing a Network. The network is composed of one or more segments where each segment consists of 2 nodes and each node is identified by a Point which means of a pair of coordinates.
Network-1-m>Segment-1-2>Nodes------Point(x,y)
Net1 -----Segment1
-----Segment2
-----Segment3
Segment1--Node1 to Node2
Segment2--Node2 to Node3
Segment3--Node3 to Node4
Node1--X1,Y1
Node2--X2,Y2
Node3--X3,Y3
I am attaching a few jpgs to show the Tables and relationships, the table fields and values,
a query design and output based on my interpretation of your setup.
I set up the tables based on your data.
Here's the query sql
Code:
SELECT Network.NetName
, Segment.StartNode
, Segment.EndNode
, NodesCopy2.XCoord
, NodesCopy2.YCoord
, NodesCopy1.XCoord
, NodesCopy1.YCoord
FROM NodesCopy2 INNER JOIN
(NodesCopy1 INNER JOIN (Network INNER JOIN
Segment ON Network.Netid = Segment.NetId) ON NodesCopy1.NodeId = Segment.EndNode) ON
NodesCopy2.NodeId = Segment.StartNode
WHERE (((Network.NetName)="sample1"));
NOTE: The Nodes table is used (TWICE) TO
-identify StartNodes and EndNodes. I made separate copies of the Nodes Table as Copy1 and Copy2 to differentiate the use of the same table for 2 different purposes. 1 to identify StartNodes and 1 to identify EndNodes.
Good luck with your project.