Aqward Quarks Regarding Relationships & Queries in regard to Form Functionality

[nchesebro]

Here is a copy of what I am working on. In debugging the first of four forms (one is almost done, one is started, two more to start at this point) I am running into a few problems, and would like your help in resolving these issues...



These issues are located on frmReservations. I will include any related tables, queries, or forms per each issue...

Time Selection
I had this working before by looking on to another example, provided by another generous member of this forum (name skips my memory). The problem I have is the University Allows two tours M-F, at 1030AM and 0130PM, and Saturdays at 0130PM. No tours are done on Sundays. The date is entered into "Tour Date", and the after update event calculates the day given the date. Everything up to this point is in good working order. The problem takes place at the next step: The time drop down used to display the available times per the calculated day. Now, a pop up appears requesting enter parameter values. This is not how the combo box is supposed to work. It is supposed to only display the times available on that day, if any.

Nation Calculation
This is in regard to the Nation calculated field in the address area. I have all the states and provinces for the US, Canada, and Mexico in tblState, the three nations in tblNation, and have the state and nation joined together in a table tblNationState. I am assuming that by using this information, a query can be constructed to determine the nation based on the selected state. I have attempted to mimic this from the example database mentioned above, without success. May I request the proper way to construct such a query and implement it in my form?

After-Update Issue
In the section for programs of interest, when making a selection in the degree type, then selecting the appropriate program, reverting back to a different degree type and reselecting a program, it seems that the after update only fires once... For example, if I accidentally select minor when I infact intended to select bachelor, after making that correction, only the programs classified as a minor appear in the program selector. Not strong with the VBA, so I have no idea where to start or what to do... This is built using cascading combo boxes involving tblPostBaccalaureate, tblBachelors, tblMasters, tblMinors, tblAssociates, and tblCertificates. Seems to me this would better be done using a query, as it would adhere to higher order normalization standards, although I may be mistaken on this.

Ticket Requests
When a selection is made to request tickets, the ticket type is selected and the appropriate sub-types should be loaded into the following text boxes. I attempted to apply cascading combo boxes to this situation, but could not get it to work. Again, I think a query may be better suited to this, but not sure. The related are tblTickets, tblTicketType, tblAthleticTickets, tblMealTickets, and qryTicketType.


I would like to thank you in advance for diving into what seems to me, a monster collection of problems...

[orange]

I do not have acc2010. I have acc2003 so can not open your accdb.
I would suggest you read the first few (3 or 4) topics at this site to get an appreciation of what you need to do and why. You need a picture (data model) of the things you are working with and how they fit together.
http://www.rogersaccesslibrary.com/forum/topic238.html

[nchesebro]

Orange,

Not trying to be snobby in any light here, but your remark leaves me a little puzzled...

First, I think had you opened the database, you would see that it is in the most normalized form feasable for this project. That said, maybe there was something else besides the rules of normalization that you were trying to get at that I am not aware of?

I think the majority of these problems are due to calculation errors, NOT normalization errors, but since I am not the most experienced database designer in the world, I am not sure, hence, I am posting in here for help.

If someone could point me in the right direction here, I would be most appreciative.

-Nate

[nchesebro]

here is the best visual representation I can come up with for the table relationships, if this helps...

tblTour |----< tblStudent |----< tblProgram
...........|.................|-< tblAdmissionsData
...........|.................|-< tblAlumnusData
...........|-< tblDirections
...........|-< tblTickets
...........|-< tblAttendees
...........|-< tblContact