ssanfu,
Maybe you can glean some thing from this?
SOP for Nets.zip
ssanfu,
Maybe you can glean some thing from this?
SOP for Nets.zip
I think I was doing okay following that process until I got to:
3a. Use the step 2b. LIN, search for the step 2b LIN in the parent_Equipment_item_ID.
None of the values in Equip_LIN are in parent_Equipment_item_ID.
Why are values in unique_ID and equipment_item_ID identical for each record? Fields duplicate each other.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7,
That is true on the duplicate fields. It comes from the original db. I can leave a column out.
2a. Find the Radio Mount LIN from the Reference table.
2b. Determine the unique_id
I am not sure how to reference a column name for the reference table and that there are 3 columns the AN/VRC-92F may be using
Example:
VRC-92F SINCGARS long long WLS-1
VRC-92F SINCGARS long long WLS-2
VRC-92F SINCGARS long long WLS-3
Look at Figure 4, in this instance we are looking for an AN/VRC-92 (Column name found in Figure 3)
2a. LIN: R45543
2b. 3172147
3a. Use the step 2b. LIN, search for the step 2b LIN in the parent_Equipment_item_ID.
Lookup3.zip
There are plenty of errors still, I am trying to avoid using a reference table for the radio LINs/Channels etc, but your comment leans me more towards that.
Then the statement would be better worded:
3a. Use the step 2b., search for the Unique_ID in the parent_Equipment_item_ID.
Statements like "2a. Find the Radio Mount LIN from the reference table." do not help alleviate confusion. I presume the 'reference table' is the Data table because that is the table with Equip_LIN field and that is the field intended by 'Radio Mount LIN'.
Back to step 3a. A self-join query may be helpful to pull info associated with the parent_equipment_item_ID.
Clarify - "4a. Find the radio Type Lin from the reference table." - is this the LIN of the parent_equipment_item_ID?
Consider:
SELECT Data.Netbase, Data.ParaTest, Data.[Role / FE / Node Name], Data.[Equip LIN], Data.unique_id, Data.parent_equipment_item_id, Data_1.[Equip LIN] AS ParentLIN
FROM Data AS Data_1 INNER JOIN Data ON Data_1.equipment_item_id = Data.parent_equipment_item_id;
Will stop there for now.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
"4a. Find the radio Type Lin from the reference table." - is this the LIN of the parent_equipment_item_ID?"
This is finding the Radio LIN, the previous step was for finding the Radio Mount LIN.
Radio Mount: AN/VRC-92F LIN: R45543
Radio Type: RT-1523(C)/U LIN: R30343
Updated SOP SOP for Nets.zip
June, Ranman,
See post 7 on the link to see if this clarifies what I am up to.
https://www.accessforums.net/showthread.php?t=69823