C
carriey
Just thought I'd repost this and see if anyone can give me some advice....
I have one table Compl_Main_Tbl with unique Inspec_ID. We have a number of
"sites" that will be physically inspected by govt. agencies and we will
receive Satisfactory or Unsatisfactory assignments. All the specifics about
the inspection are in the main table (ie. Inspector_Name, Govt_Agency,
Enforcement_Level, Date_Issued).
Each "site" has a number of "locations" assigned to them (actually called
UWI). Any or all of the UWI's at that site could be inspected at once and
included in the one inspection. And they can be enforced for more than one
issue (ie. noise, emissions, staining....). So, I have the details of the
inspection in the Detail_Tbl and linked one-to-many to Compl_Main_Tbl.
Each UWI actually has been assigned a breakdown based on geographical area
and the company I work for has built two Oracle databases that I am supposed
to link into (because the areas will change). I am not able to change the
structure of these two tables.
One is called UWI_Corp_Hier and incl. these fields that I need:
District_Code, District_Name (Sub-District, Area, Field)
The other table is called UWI_Points and it includes these fields that I
need: Survey_Sys and UWI. The two tables are linked by the Field_Code.
What I need is to be able to type in the UWI and have the rest of the fields
from the UWI tables fill in. Then I need to add some data that is currently
in the Detail_Tbl.
I have built the main part of the database into a form and in the past I
have added a sub-form for detail information but, I am unsure how to do this
when I really have three tables that I need to work with. I was thinking
that maybe I could build a query based on the three tables and put that in
the sub-form but I'm not sure if this is appropriate. I also am not sure how
to get the other info to fill in; I've been searching the newsgroups and I
think I may need to make them combo boxes.
Thanks again!
I have one table Compl_Main_Tbl with unique Inspec_ID. We have a number of
"sites" that will be physically inspected by govt. agencies and we will
receive Satisfactory or Unsatisfactory assignments. All the specifics about
the inspection are in the main table (ie. Inspector_Name, Govt_Agency,
Enforcement_Level, Date_Issued).
Each "site" has a number of "locations" assigned to them (actually called
UWI). Any or all of the UWI's at that site could be inspected at once and
included in the one inspection. And they can be enforced for more than one
issue (ie. noise, emissions, staining....). So, I have the details of the
inspection in the Detail_Tbl and linked one-to-many to Compl_Main_Tbl.
Each UWI actually has been assigned a breakdown based on geographical area
and the company I work for has built two Oracle databases that I am supposed
to link into (because the areas will change). I am not able to change the
structure of these two tables.
One is called UWI_Corp_Hier and incl. these fields that I need:
District_Code, District_Name (Sub-District, Area, Field)
The other table is called UWI_Points and it includes these fields that I
need: Survey_Sys and UWI. The two tables are linked by the Field_Code.
What I need is to be able to type in the UWI and have the rest of the fields
from the UWI tables fill in. Then I need to add some data that is currently
in the Detail_Tbl.
I have built the main part of the database into a form and in the past I
have added a sub-form for detail information but, I am unsure how to do this
when I really have three tables that I need to work with. I was thinking
that maybe I could build a query based on the three tables and put that in
the sub-form but I'm not sure if this is appropriate. I also am not sure how
to get the other info to fill in; I've been searching the newsgroups and I
think I may need to make them combo boxes.
Thanks again!