S
Sarah Stockton
I have a QrtSecs Table in Qtr_Sec_List database, this table consists of two
fields SecNumber( an autonuber) and QtrSec (a text field) ( I have linked
this table into the database called LeakSurveys. Then I have a table called
MapSites it contains a field called QuarterSect this field is a lookup value
from the linked QrtSecs. Then I have a table called LeakSurveyRecord it has a
one to many relationship with MapSites.
Here is where my problem lies:
I have a form "LeakSurveyRecord" that has a subform "MapSites" when I try to
fill in the subform for the form it has one field that is alread filled out,
and I can't type over it, if I try it gets kicked below what I am typing in
another row. I also get a error code that says that I can't enter the data I
want because it has to have a related record in the Leak Survey Record table.
Please help.
Thank you
Sarah
fields SecNumber( an autonuber) and QtrSec (a text field) ( I have linked
this table into the database called LeakSurveys. Then I have a table called
MapSites it contains a field called QuarterSect this field is a lookup value
from the linked QrtSecs. Then I have a table called LeakSurveyRecord it has a
one to many relationship with MapSites.
Here is where my problem lies:
I have a form "LeakSurveyRecord" that has a subform "MapSites" when I try to
fill in the subform for the form it has one field that is alread filled out,
and I can't type over it, if I try it gets kicked below what I am typing in
another row. I also get a error code that says that I can't enter the data I
want because it has to have a related record in the Leak Survey Record table.
Please help.
Thank you
Sarah