Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  1. #16
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    ssanfu,
    Maybe you can glean some thing from this?

    SOP for Nets.zip

  2. #17
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    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.

  3. #18
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    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.

  4. #19
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    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.

  5. #20
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    "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

  6. #21
    Thompyt is offline Expert
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2014
    Location
    El Paso, TX
    Posts
    839
    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

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Find related data in a table
    By paultje_bos in forum Queries
    Replies: 4
    Last Post: 12-05-2016, 04:49 AM
  2. Replies: 3
    Last Post: 06-26-2014, 08:35 AM
  3. Replies: 7
    Last Post: 10-15-2012, 09:48 AM
  4. Replies: 4
    Last Post: 07-09-2012, 01:49 PM
  5. Place a table value in a textbox
    By justhininabouti in forum Programming
    Replies: 2
    Last Post: 11-26-2011, 10:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums