Design Question - Need suggestions for Creating Related Records

Susan Bricker

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

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #1

Subscribe Reply

1849

Susan Bricker

Did I cross some sort of line, here, with this post? I am concerned
because I have received no replies and I thought that I would have seen
many different opinions to my question. If this is in the wrong list,
please let me know which list would be more appropriate.
Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #2

Parts Manager

"Susan Bricker" <sl*****@verizo n.net> wrote

Did I cross some sort of line, here, with this post? I am concerned
because I have received no replies and I thought that I would have seen
many different opinions to my question. If this is in the wrong list,
please let me know which list would be more appropriate.

------
Original Posting
From: "Susan Bricker" <sl*****@verizo n.net>
Subject: Design Question - Need suggestions for Creating Related Records
Date: Monday, April 25, 2005 7:50 AM
-------

I show about 11:50 AM PST right now.

Sue, maybe because it has only been a couple of hours since your post?

Not everyone is on 24/7. :-)

I would say give it time for people to read and respond before thinking ill
of your post.

Tim

Nov 13 '05 #3

Susan Bricker

Tim,

You mean EVERYONE is not on EST? : ) I'll try my best to have some
patience. Thanks for replying to the post.

Sue

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #4

pietlinden

just my opinion, but you could do something like disabling controls
until the user has filled in the ones you want. (kind of a nuisance if
they know what they're doing, but then you do have control that way).
So you could check the current control in the AfterUpdate event or so
(Check ADH, I'm sure it has all this!) and then enable the next
control. Also, you could use a boolean flag to disable the closing of
the form (again, see ADH - Developer's Handbook). If you're reasonably
comfortable with coding you shouldn't have too much trouble with it.
and the solutions in there you can just copy/paste into your database.

Nov 13 '05 #5

Susan Bricker

Thanks for the input. Your suggestions sound pretty good. I'll check
out the ADH. Thanks.

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #6

rkc

Susan Bricker wrote:

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.

Since your application probably isn't going to be used for the rapid
entry of dozens of records at a time I see no problem with opening an
individual form to create an Event and another to add a Trial to the
Event. The Class information would of course be entered on the Trial
entry form since there is only one piece of information about a class.

The only fool proof way of forcing the entry of data into a field before
a record is saved is to set the required property of the field to yes
in the table design. Methods of trying to do it via the GUI have been
discussed hundreds of times here. Google Groups is your best bet for
reading all about that until your eyes bleed.

Nov 13 '05 #7

Susan Bricker

rkc,

Thanks for the input. You've been great help. I'll head over to Google
right away. Bleeding eyes??? ... What an image. : )

Regards,
SueB

*** Sent via Developersdex http://www.developersdex.com ***

Nov 13 '05 #8

Similar topics

3856

FrontController Design Pattern and Code Reuse

by: bigoxygen | last post by:

Hi. I'm using a 3 tier FrontController Design for my web application right now. The problem is that I'm finding to have to duplicate a lot of code for similar functions; for example, listing users, and listing assignments use similar type commands. Is there a "better" way I can organize my code?

PHP

1492

Is this correct OO design?

by: cmo63126 | last post by:

I'm not sure if this is bad design or not. It seems flawed, but I'm not sure. Is it wrong to create an instance of a class within the class itself? Any feedback appreciated. public class Article { int articleID; string title; //Constructor: Load Data from DataAccess Class

.NET Framework

2133

Table Design- one or many?

by: kimi | last post by:

I have just started working on a project that is partially complete. It is an application that is using access to store test results. The test results are being stored in two Access 2000 databases. DB #1 = StudentDB DB #2 = TestResulstsDB Why are there 2 dbs? I do not know - but that is one of the tings that we will be changing. Combining all of the data into one database.

Microsoft Access / VBA

1956

Class Design and Re-use

by: krs | last post by:

Hi, I'm using the MS timetracker app as a basis for an application I am building. I have at present two classes, Site and SitesCollection, similar to the timeentry and timeentrycollection classes. These classes use the ms sqlhelper class as a data access layer. I've now created a web form that uses the site and sitescollection classes to build a collection of site objects from the database and display them in a datagrid. I have also...

ASP.NET

4484

VB6 app may need to generate its own ACCESS AUTONUMBER VALUES???

by: Alan Mailer | last post by:

A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any AutoNumber* fields in them. Correct me if I'm wrong, but I'm assuming this means that I cannot now alter these existing Access tables and change their primary key to an "AutoNumber" type. If I'm right about this, I need some suggestions as to the...

Microsoft Access / VBA

2502

Laws and Myths of Usability & Interface Design

by: YellowFin Announcements | last post by:

Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses is because most of the tools are so difficult to use and reveal so little

Microsoft SQL Server

4089

Code to add a field to multiple tables in design mode

by: rdemyan via AccessMonster.com | last post by:

I have a need to add another field to all of my tables (over 150). Not data, but an actual field. Can I code this somehow. So the code presumabley would loop through all the tables, open each table in design mode and then add the new field and set its properties. Thanks. --

Microsoft Access / VBA

6996

Database design question - Isolated, unrelated tables

by: nyathancha | last post by:

Hi, I have a question regarding best practices in database design. In a relational database, is it wise/necessary to sometimes create tables that are not related to other tables through a foreign Key relationship or does this always indicate some sort of underlying design flaw. Something that requires a re evaluation of the problem domain? The reason I ask is because in our application, the user can perform x

Microsoft SQL Server

1340

Database design questions

by: David | last post by:

Hi list. I have a few database-related questions. These aren't Python-specific questions, but some of my apps which use (or will use) these tables are in Python :-) Let me know if I should ask this on a different list. Question 1: Storing app defaults. If you have a table like this:

Python

8233

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8170

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8675

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

7158

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6108

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4173

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2604

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1784

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1482

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General