G
Giem
Hey all,
My database has a form that makes a new record for the user to enter
information in a table called REPAIR. It works fine, but I have another form
that displays this information, then a subform to enter additional
information from another location in the department in a table called INSTAT.
When this second form loads the subform tied to INSTAT is blank, obviously
because there is no record in INSTAT that ties it to REPAIR. It does the same
if you skip the subform and try to query both tables on the main form
obviously as well.
I have the parent/child link set up in the subform and the recordsource as
INSTAT in the subform. I have an autonumber primary key in REPAIR that has a
1 to 1 relationship to a regular number field in INSTAT. I understand that
splitting the tables is not really necessary from a data standpoint, but I
wanted to separate the data to make it easier to work with for my benefit
(between the tables it's probably over 60 fields). Assuming this, what is the
best way to make a record in INSTAT that ties to a record in REPAIR so the
subform (or just a query of everything in the main form) will work properly?
I'm guessing you want to make a new record in INSTAT when you make a new
record in REPAIR, just don't know the best way to do that.
Thanks in advance.
My database has a form that makes a new record for the user to enter
information in a table called REPAIR. It works fine, but I have another form
that displays this information, then a subform to enter additional
information from another location in the department in a table called INSTAT.
When this second form loads the subform tied to INSTAT is blank, obviously
because there is no record in INSTAT that ties it to REPAIR. It does the same
if you skip the subform and try to query both tables on the main form
obviously as well.
I have the parent/child link set up in the subform and the recordsource as
INSTAT in the subform. I have an autonumber primary key in REPAIR that has a
1 to 1 relationship to a regular number field in INSTAT. I understand that
splitting the tables is not really necessary from a data standpoint, but I
wanted to separate the data to make it easier to work with for my benefit
(between the tables it's probably over 60 fields). Assuming this, what is the
best way to make a record in INSTAT that ties to a record in REPAIR so the
subform (or just a query of everything in the main form) will work properly?
I'm guessing you want to make a new record in INSTAT when you make a new
record in REPAIR, just don't know the best way to do that.
Thanks in advance.