473,561 Members | 3,340 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Design Question - Need suggestions for Creating Related Records

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
7 1844
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
"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
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
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
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
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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
3850
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?
4
1491
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
15
2131
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....
7
1956
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...
11
4473
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...
0
2493
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...
5
4085
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. --
12
6980
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?...
0
1337
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:
0
7647
marktang
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...
0
7930
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6210
agi2029
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...
1
5472
isladogs
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...
0
3617
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3600
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2068
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
1
1181
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
896
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.