I would like to create a database to store the following:
Special Events Total (calculated field to add the other fields)
Special Event A (number)
Special Event B (number)
Special Home Events
Special Home Events Total (calculated field to add the other fields)
Special Home Event A (number)
Special Home Event B (number)
Special Event Date
Special Event Total
Special Home Event Total
so it looks simple and I almost got it, but somehow I can't get it to work.
So what I would like is Table A and B to share the Date field from Table C, so this field is unique and how I would like to search for and all tables will share this key field content.
Table C will have a copy of the totals for Table A and B, I get an error that Calculated fields can be in a system relationship.
So my vision is to have a Form where there is:
- Date field (this would be the Date field from Table C)
- Special Event A (number)
- Special Event B (number)
- Special Home Event A (number)
- Special Home Event B (number)
- Total for Special Event (from Table C)
- Total for Home Special Event (from Table C)
I am not sure if there will be subforms and queries need to be created for Special Events and Special Home Events table. Ideally, I open the form, enter the date and data, and the fields (date and totals) replicate to where is necessary.
all my attempts have failed, I have to lookup the date in a drop box and I don't want that, I want the date to show on Table A and B when I enter the date on Table C, and vice versa, when the total is calculated on Table A and B, this number should be displayed on Table C.
Let me know how I can accomplish this, it's been a while since I've use Access and I used to be pretty good at it, but it seems that I need a refresh course!