Posted this in Forms, but I'll try here

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help with problem. My Database is about information gathered in various sites.

I have three Tables.

Tbl.Main
-fld.Visit_ID (Primary, Autonumber)
-fld.Observer (Text)
-fld.Latitude (Number)
-fld.Longitude (Number)

Tbl.Land Cover Types
fld.Land_Cover_Type_ID (Primary, Autonumber)
fld.Land_Cover_Type_Name (Text) (There are fifteen types, ie.. Boulder, Rock, Sand, Gravel...etc.)

Tbl.Land_Cover_Characteristics
fld.Observation_ID (Primary, Autonumber)
fld.Visit_FK (Number) (Linked to [Main].[Visit_ID])
fld.Land_Cover_Type_FK (Number) (Linked to [Land Cover Types].[Land_Cover_Type_ID])
fld.LCT_Percentage (Number) (The percentage of each cover type I am entering)

In a form, how do I get the 15 types of land cover so that I can enter them easily. I would like each 15 land cover types visible for entry in the form. Right now, with the way I have it set-up, I am required to specify the Land Cover Type and then the value.

Please help. Thanks alot

Eskimo going nuts
 
Eskimo Going Nuts,

If I understand your question, try the following.

Create a Combo Box by following the wizard (i.e.click on
the combo box tool on the toolbar then click on the form
where you wish the combo box to be, the Wizard should
automatically commence), choose the following options:

1. I want the combobox to look up values in a table or
query > Next

2.Select the table that contains the land cover values >
next

3. Select both the fields by clicking on the >> button >
Next

4.This next window will show what will be displayed. It
should be correct so just click Next

5.Choose to store that value, in the field
fld.Land_Cover_Type_FK > Next

6.Choose a label name for your newly created combo box.
Then click Finish.

Now you should be able to select the appropriate land
cover from your drop down list.

Hope this helps.

Regards

Julie
www.simply-access



-----Original Message-----
Need help with problem. My Database is about
Click to expand...
information gathered in various sites.
I have three Tables.

Tbl.Main
-fld.Visit_ID (Primary, Autonumber)
-fld.Observer (Text)
-fld.Latitude (Number)
-fld.Longitude (Number)

Tbl.Land Cover Types
fld.Land_Cover_Type_ID (Primary, Autonumber)
fld.Land_Cover_Type_Name (Text) (There are fifteen
Click to expand...
types, ie.. Boulder, Rock, Sand, Gravel...etc.)
Tbl.Land_Cover_Characteristics
fld.Observation_ID (Primary, Autonumber)
fld.Visit_FK (Number) (Linked to [Main].[Visit_ID])
fld.Land_Cover_Type_FK (Number) (Linked to [Land Cover Types].[Land_Cover_Type_ID])
fld.LCT_Percentage (Number) (The percentage of each cover type I am entering)

In a form, how do I get the 15 types of land cover so
Click to expand...
that I can enter them easily. I would like each 15 land
cover types visible for entry in the form. Right now,
with the way I have it set-up, I am required to specify
the Land Cover Type and then the value.
 
Hi Julie,

The values I would like to enter are the percentages of each land cover type. I tried your suggestion, it does work the way you intended. I have the main form with a record source being the table Main. I would like to enter the percentages of each land cover type within that form. With the 15 labels, one of each cover type and an empty space where I would put a number on each type shown.

Most of the Land Cover types will be 0 percent and that is my default. But I can tab through to a land cover type that is represented in the sites we visit. I would then be able to just enter a value for that type.

I come up with a fix, albeit a dumb fix. I just deleted my two extra tables with the land cover characteristics and land cover types and just put 15 more fields in the Main Table with number fields. I just then query from the Main table. Works for me, I am not sure why MSaccess users suggest not doing it like that.

Eskimo becoming sane
 
Back
Top