Hello, I have a question regarding adding records to a sub-form. I have completed course 1-30 and all beginner courses.
Ex; I have tables, queries, forms and sub-forms;
Main tables; DriverT with Fields like: DriverID, Fname, Lname, etc. CarT with field like: CarID, MakeIDFK, ModelIDFK, YearIDFK, CarName A junction table; CarXDriverT Supporting Tables; MakeT, ModelT, YearT
Queries; DriverXCarQ; with Fields: CarXDriverID, CarIDFK, DriverIDFK.
Forms: A main Form; CarF with the fields from the CarT and a subform; DriverXCarSubF The subform get data from; DriverXCarQ
I want to be able to add a new Driver to the DriverT in the form the main form in the sub-form.
Any Ideas? Is this in an upcoming course? A past course? Thanks it really kicking my butt.
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 Expert 30.
