A
akchris
I have 3 major tables: tbl_grid (parent), tbl_point (child), tbl_date
(grandchild) (each grid has multiple points that are visited on various
dates....there are then multiple "great-grandchild" tables that relate to
tbl_date). The primary key for tbl_grid is grid_code (5-digit #) while
grid_name is the common text name of the grid. grid_code is the foreign key
to tbl_point, whose primary key is point_code. Point_number is a 1- to 2-
digit number for the point. (point_code is a concatenation of grid_code and
point_number). point_code is a foreign key to tbl_date, whose primary key is
date_code. date_number is year+julian date. (point_code is a concatentation
of grid_code + point_number + date_number).
frm_point is a subform of frm_grid. There is then a frm_date which has many
subforms within it. We refer to grids generally by a grid_name and not by
its 5-digit grid_code. In frm_date, while the 5-digit grid code is contained
within the date_code, I would like to add a reminder field of the text name
of the grid to the form. Unfortunately, I do not know how to add a field
from the parent table (that is, grid_name in tbl_grid) to the grandchild form
(frm_date). I would like this field to actively reflect the common name of
the grid as I change date_number in frm_date (recall that date_number
contains the 5-digit code of the grid as part of its concatenation).
I've tried several days to figure this out, but finally gave up. The best I
was able to do was provide a command button in frm_date that opens up
tbl_grid as a lookup table to look up grid common names for their codes.
However, I would rather have an auxiliary field where grid name automatically
display as the date_number changes.
Hope this makes sense. Can someone help???
(grandchild) (each grid has multiple points that are visited on various
dates....there are then multiple "great-grandchild" tables that relate to
tbl_date). The primary key for tbl_grid is grid_code (5-digit #) while
grid_name is the common text name of the grid. grid_code is the foreign key
to tbl_point, whose primary key is point_code. Point_number is a 1- to 2-
digit number for the point. (point_code is a concatenation of grid_code and
point_number). point_code is a foreign key to tbl_date, whose primary key is
date_code. date_number is year+julian date. (point_code is a concatentation
of grid_code + point_number + date_number).
frm_point is a subform of frm_grid. There is then a frm_date which has many
subforms within it. We refer to grids generally by a grid_name and not by
its 5-digit grid_code. In frm_date, while the 5-digit grid code is contained
within the date_code, I would like to add a reminder field of the text name
of the grid to the form. Unfortunately, I do not know how to add a field
from the parent table (that is, grid_name in tbl_grid) to the grandchild form
(frm_date). I would like this field to actively reflect the common name of
the grid as I change date_number in frm_date (recall that date_number
contains the 5-digit code of the grid as part of its concatenation).
I've tried several days to figure this out, but finally gave up. The best I
was able to do was provide a command button in frm_date that opens up
tbl_grid as a lookup table to look up grid common names for their codes.
However, I would rather have an auxiliary field where grid name automatically
display as the date_number changes.
Hope this makes sense. Can someone help???