Current record vs VBA and make record

[Ruegen]

Currently for a new booking I have a many to many relationship that has the booking as the subform and the person (teacher table) booking as the main form.



So you create the ID for the main form first when you open (data entry) then you click in the subform and it creates the ID's in the junction table and ID in the booking table

However this causes problems if I need to undo the records (as they have been created).

I want to be able to cancel or make

If I program unbound text boxes on a form - can I have the information tied to variables, then use those to make a new record that goes across the junction like explained above? would it cause any errors?

I am assuming I would create 3 new records (tblTeacher, tblJunction, tblBooking) and collect new ID for tblTeacher and tblBooking (which I don't know how to collect) and then put those two records into the newly created junction table to tie them all together - all done using VBA.

That way any form information added to the booking would be only held in a variable until they have pressed save or cancel.

Any recommendations?

(also my next question is once I programme in to make a new record how to I get access to return that newly created record ID using VBA?)

[Xipooo]

Currently for a new booking I have a many to many relationship that has the booking as the subform and the person (teacher table) booking as the main form.

So you create the ID for the main form first when you open (data entry) then you click in the subform and it creates the ID's in the junction table and ID in the booking table

However this causes problems if I need to undo the records (as they have been created).

I want to be able to cancel or make

If I program unbound text boxes on a form - can I have the information tied to variables, then use those to make a new record that goes across the junction like explained above? would it cause any errors?

I am assuming I would create 3 new records (tblTeacher, tblJunction, tblBooking) and collect new ID for tblTeacher and tblBooking (which I don't know how to collect) and then put those two records into the newly created junction table to tie them all together - all done using VBA.

That way any form information added to the booking would be only held in a variable until they have pressed save or cancel.

Any recommendations?

(also my next question is once I programme in to make a new record how to I get access to return that newly created record ID using VBA?)

http://support.microsoft.com/kb/304466

Check out the part on "Referential Integrity" and "Cascading Updates and Deletes".

[Ruegen]

http://support.microsoft.com/kb/304466

Check out the part on "Referential Integrity" and "Cascading Updates and Deletes".

That's all good - I already have the many to many relationship.

I want to change the way I currently add records in the database - currently I do it as described above but I want to switch it all to VBA to do the same thing.