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 relation****p 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.
