calumbus53
New Member
- Joined
- Feb 22, 2018
- Messages
- 17
Hi guys, I need help.
I need to build a sequence of look up tables which are all interlinked. They will be accessed through multiple Data Validation list on the main page, so will be need to remain unedited.
Here is a sample of the data I am trying to interlink through indirect lists.
<colgroup><col width="64" style="width: 48pt;" span="5">
<col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;">
<col width="64" style="width: 48pt;">
<col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;">
<col width="64" style="width: 48pt;">
<col width="26" style="width: 20pt; mso-width-source: userset; mso-width-alt: 950;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
I need to build a sequence of look up tables which are all interlinked. They will be accessed through multiple Data Validation list on the main page, so will be need to remain unedited.
Here is a sample of the data I am trying to interlink through indirect lists.
Parent | 1st Child | 2 Child | ||||||||
10.02.02 | a | a2.1 | aa2.1 | 10 | a | |||||
10.03.03 | a | a3.1 | aa3.1 | a | 01 | a1.1 | ||||
11.02.02 | b | b2.2 | bb2.1 | a | a1.2 | 01 | aa1.1 | |||
a | a1.3 | aa1.2 | ||||||||
a | a1.4 | aa1.3 | ||||||||
a | a1.5 | aa1.4 | ||||||||
a | ||||||||||
a | 02 | a2.1 | ||||||||
a | a2.2 | 02 | aa2.1 | |||||||
a | ||||||||||
a | 03 | a3.1 | ||||||||
a | a3.2 | 03 | aa3.1 | |||||||
a | a3.3 | aa3.2 | ||||||||
a | ||||||||||
a | 04 | a4.1 | ||||||||
a | a4.2 | 04 | aa4.1 | |||||||
11 | b | |||||||||
b | 01 | b1.1 | ||||||||
b | b1.2 | 01 | bb1.1 | |||||||
b | ||||||||||
b | 02 | b2.1 | ||||||||
b | b2.2 | 02 | bb2.1 | |||||||
b | b2.3 | bb2.2 | ||||||||
b | ||||||||||
b | 03 | b3.1 | ||||||||
b | b3.2 | 03 | bb3.1 |