Ok, screenshot in the link below:
Here
Excuse the size
Basically its a simple MDI frame with two main forms - Find and Person. Opening find calls a SQL view that returns a little info about each person (firstname, lastname etc). Double click any of the rows opens the Person form and populates all of the details (calling a SQL stored procedure for the dataset). If I want to create a new person, click the new person button and it opens the Person form, minus any details.
It started off cunningly simple, and I have added complexity over time to incorporate new things learnt (needless to say I look at some of the code and cringe now!).
The way I see your app working is broadly similar. You'd habe a Find form that returns a list of records (you could filter this by name or date if you expect multiple records and for ease of use). Once you've found the record, double lick the row and it opens a detail form (with Save/Delete buttons as appropriate).
Here
Excuse the size
Basically its a simple MDI frame with two main forms - Find and Person. Opening find calls a SQL view that returns a little info about each person (firstname, lastname etc). Double click any of the rows opens the Person form and populates all of the details (calling a SQL stored procedure for the dataset). If I want to create a new person, click the new person button and it opens the Person form, minus any details.
It started off cunningly simple, and I have added complexity over time to incorporate new things learnt (needless to say I look at some of the code and cringe now!).
The way I see your app working is broadly similar. You'd habe a Find form that returns a list of records (you could filter this by name or date if you expect multiple records and for ease of use). Once you've found the record, double lick the row and it opens a detail form (with Save/Delete buttons as appropriate).