Re: Need a hand, any help appreciated

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 03/09/04 

Date: Mon, 08 Mar 2004 23:48:29 -0700

On Mon, 8 Mar 2004 10:00:39 -0600, ross863
<ross863.12u72k@nospam.MSAccessForum.com> wrote:

>
>Lo all
>
>I have a 'query' about Access. I'm making a system for my Tennis club
>and I want a funtion that, when the end-user has filled in the 'Arrange
>a Lesson' form, the details on the form save to a table or report or
>somthing of that description, and can be printed out after. Is this
>possible or is there a next best alternative? I have made a form called
>'Arrange a Lesson' which has fields concerning which coach and which
>member is taking and having the lesson e.g. memberID and lesson time.
>I'm pretty much a novice when it comes to Access, so do i need to
>create relationships or any of that craic?

Well... you're going about this pretty much in the same way as a
tennis student who's never hit a ball asking how to control a running
backhand. You're going about it wrong end first!

Access stores data in Tables. The Tables, and their relationships, are
the foundation. A Form *IS JUST A TOOL* to let you view and edit data
in a Table; a Report is a way to get the data in one or more tables
out to paper.

You will want to design your tables *first*, and then design the forms
to fit the tables, not the other way around. You'll need a table of
Coaches, a table of Members, a table of Lessons; you'll probably want
a Form based on the Members table with a subform based on the Lessons
table... but get the tables and their relationships right *first*,
just as you'ld teach a tennis student to hold the racket correctly
first!

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Relevant Pages