Create a new record in a tbl using another record from a diff tbl

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

Guest

I have a tbl that contains the case # it is unique and must stay that way. we
create the unique # there and then use it in 1 to 5 other forms that create
different types of information that needs to be kept seperate. Is there a way
that I can have the user enter the required info in the case # tbl and then
when they select a cmd button to go create a new record in a different form I
can bring the case # and the other info from the case # form with them and
open a new record in the other tbl with the info filled from the first form.
I have tried to use a query but can not find a way to select the last record
entered in the case # table. I hope this makes since.
 
Sounds like you need to set a one-to-many relationship between your tables.
When you do that you can use a form/subform with these tables and
automatically add a record in the subform (stored in the many side table).
 
I am entering it using a subform now. How can I read the entry that the
client enters. all he enters is the name and I generate the case # by
autonum. I need the autonum and the name to pass to the next record when the
client presses a cmd button. I do not understand how the one to many
relationship can help here.
 
The orginal data entry is the case# in the main form which the one side of
the one-to-many relationship. The subform data is from the many side.
 
Back
Top