473,396 Members | 2,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

form design with tabs, subforms, and multiple entries for one record

I am currently working on a database, in 3rd normal form, which is for
candidates who apply for a job with the law firm that I

workd for. My issue is with good form design.

I have a main form. Then I have 3 pages on a tab control ( 4 if the
type of candidate validates that is is to be shown) Each page

has a subform. The subforms can be either single or continuous, I
think I am still deciding what I want to lock down this entry form

to make entry easy.

my main menu - http://www.geocities.com/misscrf/images/newmenu.jpg

The main form is just for name and email and candidate type. If the
candidate type is one of a few types a page becomes visible

for specific info information if candidate is attorney type -
http://www.geocities.com/misscrf/ima...ith4thpage.jpg ,

otherwise, there are just 3 pages. 1 is for addresses. my old address
tab and subform -

http://www.geocities.com/misscrf/ima...ddtabshows.jpg An
applicant can have multiple addresses (home, work,

school etc), another is for phone numbers. my old phone tab and
subform -

http://www.geocities.com/misscrf/images/phonetab.jpg An applicant can
have multiple phone numbers.

The last page is for the applications for that candidate. application
tab with application and acitivity subform -

http://www.geocities.com/misscrf/ima...ctivitytab.jpg
A candidate could apply more than once, so they could have more than
one application. This will get tricky because the

application form has a subform, for the activities relevant to that
application. This is like a logical history. Activity - interview

scheduled, interview held, offer extended, rejection letter sent, etc.

Anyway, I am looking for advice on many issues. How to best control
the subforms, how to make it so that when the user is

tabbing it goes from the last field on one subform to the first field
on the next subform, and more. My hestitation is that I think I

need to make sure that there aren't more address, phone numbers,
applications or activities needed to be added at that time. My

next hesitation is that I don't want to be stopping the user with
messages every 5 seconds.

I have been playing around and consolidated the phone and address, and
taken all maintenance buttons off of the entry form. I

think this is a better direction, but I am still not sure how to make
this look and work in a solid manner.

maintenance menu for maintenance types -
http://www.geocities.com/misscrf/ima...enancemenu.jpg

my new consolidated tab for address and phone -
http://www.geocities.com/misscrf/images/contactinfo.jpg

Here is the issue. If you look at the address and phone subforms
(consolidated onto one tab) , you see that there are fields for 1

record, and an add button.

I am trying to figure out how to format and set up my subforms, so that
the tabbing can go straight through from the first field

(salutation) to the last field on this form, which is Followup/followup
notes, on the activity subform.

The thing is that I need to account for the possibility that a user
would need to enter in multiple addresses, phone numbers,

applications, or activities.

I do not know how to make this appear on the form in a way that will
make sense to the end user.

The old phone tab (
http://www.geocities.com/misscrf/images/phonetab.jpg )
showed a way of using a continuous form so that when a first phone is
added a second record opens up. I think I kind of liked

that.

The old address tab (
http://www.geocities.com/misscrf/ima...ddtabshows.jpg )
shows the form with navigation tab. I didn't like this because when a
user tabs from the zip field, the record they are on

disappears. It looks that way to the end user. The navigation buttons
show that the form has moved to a second record, but the

end user might get confused by that setup.

Here is my challenge for applications and activities.

The tab right now (
http://www.geocities.com/misscrf/ima...ctivitytab.jpg )
does not account for a second

application. I put the previous and next buttons there, but stopped
because I was unsure. I could put a new record button there

too, since it is single form cycle current record.

The activities has the navigation buttons and cycles all records (
based on application id, which ties to candidate id) but again this

has the same problem as address.
Any suggestions would be wonderful. I would really love to see some
screen shots as well.

If you would like to see table relationships and detail I have those as
well:

http://www.geocities.com/misscrf/ima...ationships.jpg
http://www.geocities.com/misscrf/tabledefinitions.html

Nov 13 '05 #1
0 2668

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

Similar topics

2
by: Pete | last post by:
Before I get started with the question, does anyone have a (single) good book recommendation for database design? Not an Access-specific book, but something geared toward helping me figure out...
4
by: William Wisnieski | last post by:
Hello Everyone, Access 2000 I have a form with multiple pages on it. There is one text field on the third page of the form that I need the user to complete before leaving the form or moving...
4
by: Mike MacSween | last post by:
It's a form, with (so far) 4 tab pages on it, each of which holds 2/3/4 subforms. (I like tabbed forms by the way - do we all?) Basically the subforms are different ways of looking at the...
25
by: Lyn | last post by:
Hi, I am working on a genealogy form. The only table (so far) lists everybody in the family, one record per person. Each record has an autonum ID. The parent form (frmMainForm) displays the...
5
by: tdmailbox | last post by:
I have a form with a child form. In the child form there is a list of names that can grow quite large. On the parent form I want to display the first name from the child form. I set up a test...
8
by: Martin | last post by:
I hope not, but, I think the answer to this question is "it can't be done". Northwind sample database. Orders form. Go to a new record. Select a customer in "Bill To:" Don't enter any...
6
by: Jack | last post by:
Hi, I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age. The form...
3
by: ApexData | last post by:
I'm starting a new project. A Personnel System. I have considered opening a single bound form to the main employee table. The user can scroll the records to any individual. I would like to have a...
4
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
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...
0
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,...

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.