Re: Anybody?

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1145222951.39386_at_yasure.drizzle.com...
> Dereck L. Dietz wrote:
> > Is there anybody who will try to help me with this problem? I'm at a
> > complete loss at to why forms is requiring at least one batting record
to
> > exist while it does not require at least one pitching record to exist
when I
> > have both blocks set up the same way with the only differences being the
> > table they are based on.
>
> Glad to help you.
>
> What version of Forms?

Forms [32 Bit] Version 6.0.8.11.3

> How many data blocks in the form?

Five (5) in total

1 - PLAYER
2 - BATTING
3 - PITCHING
4 - BIO
5 - TOOLBAR

> How are they related?

1 - PLAYER is used to enter the player first and last name. It then checks the PLAYER table and, if a match is found, retrieves the Player_ID field into PLAYER.KEY_PLAYER_ID and also the values which are contained in the BIO block. If no match is found a new Player_ID (which is merely a sequence) is generated. The cursor is then placed in the BATTING block.

2 - BATTING is used to enter batting information and populate the Batting table. Information is retrieved by a block level WHERE clause defined in the block property pallette. The data is related to the PLAYER block with BATTING.PLAYER_ID = PLAYER.KEY_PLAYER_ID 3 - PITCHING is used to enter pitching information and populate the Pitching table. Information is retrieved by a block level WHERE clause defined in the block property pallette. The data is related to the PLAYER block with PITCHING.PLAYER_ID = PLAYER.KEY_PLAYER_ID 4 - BIO is used to enter biographical information and populate the Player table. This block is loaded when a PLAYER_ID is found.

5 - TOOLBAR. This block is simply a control block with icons for such actions as save, exit, clear screen etc.

> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Sun Apr 16 2006 - 17:08:52 CDT