Relationships: Main and detail

[CLY]

I am having trouble figuring out how to relate a number of tables. I have a
Main Table Compl_Main that will end up also being my Main form (Unique ID:
Compl_ID)

I have a Detail Table Detail_Main that I will be putting into a subform
(Unique ID: Det_ID). These two tables have a one-to-many-relationship. I
set up a field called UWI_Link

Our company has a Corporate Hierarchy that I need to tie into on the detail
level and it consists of two linked tables.

Table: UWI_POINTS this contains the UWI which is the field that will be
unique as well as fields: Location_ID and Location_Name which I also need to
display

Table: UWI_CORP this contains other fields such as District, SubDistrict,
Area that I also need to display and is linked to UWI_POINTS by Location_ID

Currently, I have set up a One-To-Many Relationship with UWI_Link in
Compl_Detail and UWI in UWI_POINTS

What I need is for the User to type in the Header info on the form and in
the subform type in the UWI (or select from drop down) and have all the other
fields fill in with the correct data. The user will then have some other
fields to fill out. How do I get all these fields from the two UWI tables to
fill in? Thanks!