Rick, loving the content! Wanted to provide an efficiency tip.
For the Tuition Levels 1 lesson, I think this was a great opportunity to show a fast way the PriceT could have been populated with the unique combinations using an Append Query.
1. Create GradeLevelT and TuitionLevelT like the video. 2. Create a ChildCountT with only one field - a number field. 3.Create PriceT much like the video except the child field would be ChildCountID now. 4. Go to Query Design and add GradeLevelT, TuitionLevelT, and ChildCountT to the query. 5. Add the ID from each table to the query builder and set sort to ascending on each field. 6. Viewing the query displays a list of every unique combination of the 3 tables. 7. Set query to Append Query, select PriceT, and run. 8. Only thing left would be to enter price values which would be easier to do after the form from the video is created.
This would be a helpful method if the dataset of each of the helper tables were fairly large.
Excellent tip, thank you very much for sharing. Sorry it took me so long to see this when the website was super slow. I didn't spend that much time in the forums, but I'm trying to go back and catch up now, so I appreciate the tip. I hope this helps future students who take the course.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 13.