Record validation (1 Viewer)

[amirkharkongor]

I have uploaded one demo Database.

In an athletic meet each participant can participate in only two Events (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put(5.00Kg), Discuss (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays)

An athlete can participate in 2 (two) individual events and one Relay only.

a) If the two individual events are track events, only one of these individual races should be longer than 200M for example: -

Sample:

Only the following combination of track event are allowed

1. 100m & 200m / 100m & 300m / 100m & 400m / 100m & 800m / 100m & 1500m/100m & 2000m / 100m & 3000m.

2. 200m & 400m / 200m & 800m / 200m & 1500m / 200m & 2000m / 200m & 3000m.

The following combination to track events are not allowed

1. 300m & 800m / 400m & 800m / 400m & 1500m / 400m & 2000m / 400m & 3000m.

2. 800m & 1500m / 800m & 2000m / 800m & 3000m.

3. 1500m & 2000m / 1500m & 3000m.

4. 2000m & 3000m.

While doing the Data Entry I want to put Check / Validation so that only the above combination are allowed to be entered.

Please help me.

 

[amirkharkongor]

I have uploaded one demo Database.

In an athletic meet each participant can participate in only two Events (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put(5.00Kg), Discuss (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays)

An athlete can participate in 2 (two) individual events and one Relay only.

a) If the two individual events are track events, only one of these individual races should be longer than 200M for example: -

Sample:

Only the following combination of track event are allowed

1. 100m & 200m / 100m & 300m / 100m & 400m / 100m & 800m / 100m & 1500m/100m & 2000m / 100m & 3000m.

2. 200m & 400m / 200m & 800m / 200m & 1500m / 200m & 2000m / 200m & 3000m.

The following combination to track events are not allowed

1. 300m & 800m / 400m & 800m / 400m & 1500m / 400m & 2000m / 400m & 3000m.

2. 800m & 1500m / 800m & 2000m / 800m & 3000m.

3. 1500m & 2000m / 1500m & 3000m.

4. 2000m & 3000m.

While doing the Data Entry I want to put Check / Validation so that only the above combination are allowed to be entered.

Please help me.

It is also to be added that only the allowed combination should appear in both the Combo Box.

 

[Cotswold]

I thought the fun part of programming was working this sort of thing out for yourself.

 

[Gasman]

I thought the fun part of programming was working this sort of thing out for yourself.

Only for some, others like to be spoon fed.

 

[Cronk]

You could have at least prepared an input form .

Why do you include 300M and 600M in your table NewEvent when they are not catered for? And this table should be Events.

I earn my living from developing Access systems. I don't mind helping to solve problems but you've just banged something together and asking for all the work to be done for you.

 

[gemma-the-husky]

Why can you not do the 400 and 800?
It's a standard-ish combination. Alberto Juantorena will be livid.
Ditto 800 and 1500. Everyone does those 2.

Seb Coe might be getting the IOC to have a look at this!

 

[arnelgp]

Seb Coe might be getting the IOC to have a look at this!

its a Kinder track and field? nobody can survive that far.

 

[CarlettoFed]

You say 100m and 300m combination is allowed but the 300m event is not in the event list (100M, 200M, 400M, 800M, 1500M, 3000M, Long Jump, High Jump, Shot Put (5.00Kg) , Thread (1.5Kg), Javelin (700 gms), 4x100M & 4x400M Relays)