I am working on a school project via an online class and ran into head
scratching problem trying to figure out how to tell MS access what I
want it to do.

Real world scenario:
A building has a main phone panel called an MDF. A MDF has many boards
called "tag blocks" and each "tab block" has several line
pairs. To break out the lines on each floor (very simple version) each
floor has a "CAN". Each CAN has one or more "tag blocks" and
each "tab block" has several line pairs.

I have created the following tables: (all fields are of type number)
MDF_TB: with the following fields
MDF_ID= number representing a specific MDF_tag_block and MDF_pair
combination
MDF_tag_block= represents a specific board
MDF_pair= represents which set of wire on a specific board

CAN_TB: the following fields
--------------------------------------
CAN_ID=unique number representing a specific CAN_number, CAN_tag_block
and CAN_pair combination

CAN_number=represents a specific floor in the building

CAN_tag_block= represents specific board

CAN_pair= represents which set of wire on a specific board.

MDF_ID= Fkey to MDF_TB.MDF_ID


To_FROM_connection_TB
To_connection = Fkey to CAN_ID, lookup combo box
From_connection=Fkey to CAN_ID, lookup combo box


PROBLEM:
----------------
How do I represent the following circuit in a form?.

MDF_ID=1
MDF_tag_block=1
MDF_pair=2

Connects to

CAN_num=1, tag_block=3, pair 2

Connected to
CAN_num=2, tag_block=1, pair 3

Connected to
CAN_num=3, tag_block=4, pair 1

Then CAN_num=3, tag_block3, pair1 goes to desk #3 on the second floor.


I have been able to make the relationship between the MDF tag_block,
pair and the first CAN tag_block, pair in the circuit via the lookup
combo box and I can establish the from_connection in a DATASHEET view.
I am able to set the next link in the chain, but when I live that MDF
record set (record #1) and return to that record, the datasheet appears
to have dropped all defined connection except for the first connection.

Is this even doable in MS Access?