I have a table (EventDetails_FWDS) and a query (FWSDExt). The table includes information for a competitor. The query contains information for available divisions that a competitor can compete in. I want to create an update query that assigns the competitor to a specific division based on their age, experience, and event class.
The table contains the following fields: EDID (Primary Key), RegID (Identifies the competitior), Age, Experience, TID (identifies the tournament), EventClass, and DivCode
The query contains the following fields: DivCode, TID (Identifies the tournamnet), EventClass, MinAge, MaxAge, ExpLessThan.
I would like to update the DivCode in EventDetails_FWDS with the DivCode from FWSDExt where the TID and EventClass in both are equal, Age >= MinAge, Age <=MaxAge, and Experience < ExpLessThan
Is this possible?