Microsoft Access 2013 Help
I have a database that I am trying to get up and running for a club I run. We are a fantasy wrestling group. We currently have 10 participants. Tables I currently have in are as follows:
* Participants (Data) (1 record of 10 entered)
* Wrestlers (Data) (1 of 10)
* Shows (Validation) (complete)
* Matches (Validation) (complete)
* Finishes (Validation) (complete)
* Points (Data, uses three prior for validation) (complete
* Master Data Table (Using all tables plus a multiplier, if needed, depending on the match type) (not yet started)
The Points table uses data from Shows, Matches, and Finishes to show every possible outcome for our league. What I don't put in that table is a multiplier for certain type of matches, since that can be any numerical value, and only in very specific matches (rare, but still need them to properly calculate points).
The Master Data table should have the Date of the event, Shows.ShowType, Matches.MatchType, Finishes.FinishType, Subtotal (ShowValue * MatchValue * FinishValue), Multiplier (Numerical, Double, Default =1), and Total Points (Subtotal * Multiplier). Furthermore, The Subtotal Field should look up the strings in the appropriate field, find the one and only record that matches it in the Points table, and return that value there. I also need the tables to properly link up in the 1 to many relationships that exist between the tables... I just can't quite get them to work out that way.
The way the Shows, Matches, and Finishes are configured are the way they must be, in order for the Points table to properly calculate the points. I do have a copy of the database I can send over, and once I get this figured out, I should be able to get myself the rest of the way done with the database to suit my needs.
I'm fairly certain a DLookup or ELookup would do the trick, but I haven't ever dabbled with Visual Basic, and would have no clue how to go about doing it right.
I work from 2p to 11p Mountain time (4p - 1a eastern) Monday through Friday, so I may be delayed in getting back to you send me a message during that time. Simbi price is flexible.