using a form to create a table

[pat67]

I am trying to run a pool league where I need to enter results. I want
to use a form to enter winners and losers to then create a table
showing all the results. So far I have not been able to figure it out.
Any advice would be appreciated.

Thanks

 

[MGFoster]

I am trying to run a pool league where I need to enter results. I want
to use a form to enter winners and losers to then create a table
showing all the results. So far I have not been able to figure it out.
Any advice would be appreciated.

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

First you create the table to hold the data then you create the form to
put the data into the table, not the other way around.

Create a table w/ a game number and a game date, plus all the other data
pertaining to a game. Then set up the form w/ the game number and date
showing (and all the other game data items). If the game number is an
AutoNumber you can set it's Locked property to Yes (since the user won't
need to change it).

Read the Access Help articles on database design (like "Creating and
Working with Databases." Look in the Help table of contents.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSjvtEoechKqOuFEgEQLtqQCfQAtyZpfGiFZoy6XFt8oFinz1YkwAoMtw
ihqmpjgmvDTP+I4A7+H4JIN3
=wjBn
-----END PGP SIGNATURE-----