?Update a linked table whilst restricting the entries with criteria from a third table

[Michael G \(Oxford UK\)]

Please can someone help or point me in the right direction.

?Update a linked table whilst restricting the entries with criteria from a
third table

List of Tables with relwevant fields only.



tblEvents

EventID

GroupsOf number of people in each event varies



tblCustomers

CustomerID



tblEventDetails

EvenDetailID

EventID many side link with tblEvents

CustomerID many side link with tblCustomers may be in
multiple Events

Handicap



tblEventDetailGroups(I only have 2 fields in this table at the moment)

EventDetailID many side link with tblEventDetails(cannot be >
GroupsOf-1 for each EventID)

EventDetailID2 many side link with tblEventDetails



An event is for example an Open Golf Challenge with say 48 entrants of
varying handicaps. Some entrants may request that they play with other
specified entrants. And entrants may play in Groups of 2 or 4 etc those that
do not request that they play with specified entrants are grouped together
by handicap upto a maximum of GroupsOf set in tblEvents.



I was going to use a sub form of tblEventDetailGroups whilst in form
tblEventDetails

And use a combo to select EventDetailID2.



Problem 1 EventDetailID2 may already be assigned to a Group for this EventID

Problem 2 How do I restrict the number of EventDetailID2 to the GroupOf -1

Problem 3 After entrants have made requests to play with other specified
entrants. Update each EventDetailID so that they are in groups of similar
Handicaps and every entrant is playing in a Group.





Thankyou in anticipation

Michael