Design Question: Updating Related Tables

[SueBwork]

Greetings.

As a relative newcomer to Access, I am having trouble deciding on how to design the form flow for updating and creating related records. I'm looking for a variety of suggestions so that I can decide what's best for the user and what's best for screen flow.

Here's the structure: I have what's called "an Event". Each Event can have multiple "Trials". Each "Trial" can multiple "Classes".

(This is the structure for a dog obedience competition)

Tables:
tblEvents - PK = eventID
tblTrials - PK = trialID, FK = eventID
tblTrialClass - PK = trialclassID, FK = trialID

Currently, for "display" or "browse": I have the following form structure:

frmEvents - single form format with a subform called sfrmTrialInfo, no navigation control - entry to this frmEvents is from an unbound pop-up form that uses a combobox to select the Event for viewing.

sfrmTrialInfo - single form format with a subform called sfrmTrailClass, has navigation control so that the user can display all trials for this event

sfrmTrailClass - continuous form format with navigation control so that user can display all classes for this trial.

My dilemma is what is the best method for letting the user create a NEW Event-Trials-Class structure. Right now I have a button on that pop-up that is used to create a NEW Event. It brings up a blank frmEvent form with the blank imbedded subforms. This is still in the design stage.

I want to have control over the data (as the user is typing ... don't let the user move forward until all requisite data is entered), but I, also, want to make the process relatively pain-free for the user.

Do you have any suggestions on a design?

Thanks, in advance, for your input.

Regards,
SueB

 

[SueBwork]

Did I make some sort of "faux pax" by posting this question to this list? I was wondering because no one is answering my post. I really thought that I would get all sorts of replies.

Seriously, if this is in the wrong list, please let me know, because I don't want to get on anyone's bad side. I have received, only, fantastic help from this and other forums.

Thanks.
SueB

 

[Mile-O]

You only posted your question a few hours ago - be patient. It is, afterall, an inernational forum and not everyone is on at the same time.

 

[SueBwork]

SJ-

Thank you for the reality check. I definitely did not remember that this is an International forum.

SueB