Navigating and populating related forms with buttons

[bphillips]

I have two forms based on tables that have a 1:M relationship. I want to create a button on the parent form that will:

(1) open the child form
(2) go to the record in the child form containing
matching data in the related field as the record
that was selected in the parent form when the button
was pushed
(3) if there is no record in the child form relating to
the record in the parent form yet, create a new
record and populate the related field with the data
from the record in the parent form.
(4) populate text boxes on the child form with
information from non-related fields from the record
in the parent form

More specifically, I have one form with fields for first name, last name and ID. When I click on a button to open another form containing records related to the first form via the ID, I want the second form to go to the record with the matching ID and populate two text boxes with the first name and last name that correlates to the ID. The first name and last name fields are not in the table that the second form is based on. Thanks for any advice/help you can provide.

 

[Rolliee]

the eassiest answer to this is an example. Post or send me your email and I will send one.

rollie@bwsys.net