I have created a flight log database to keep up with my R/C flights. I have one form to enter a flight session and then a flight form to enter new flights. The flights table has a field for SessionID which is related to the SessionID in the Session table. I have a button in the session form to add a new flight. The problem is, when I add the flight, it does not assign the same sessionID that is open to the flight. How can i make it default to the current sessionID of the corresponding form i have open. I am attaching a link to download the database, if that will help things out. I am still new to access. Maybe someone could also give me some pointers on what I have so far and let me know what i have done wrong. I am trying to learn, so any help is appreciated.
http://d01.megashares.com/dl/S8sOK3A/Flight%20Log.accdb