Append new form data to various tables?

[bloukopkoggelmander]

Hi all

A little issue I have been stuck on for many days now.

I have created a form with about 45 boxes to enter date. About 10 of these will be combo boxes that will look up data from certain tables(the user then selects the relevent choise). The rest of the boxes are all stnadard textboxes where the user enters certain info.

I also then have a save button on the bottom of the form.

What I need to happen is once the whole form has been completed and the user press Save, is for the form data to be saved to about four different tables. Now I cannot work out the easiest way to go about this. What I also want, is once the user has slected Save and during the write process, there is a problem, for a rollback operation to take place to remove data written to tables during execution, to be removed.

Hope this makes sense.

Thanks

[ADezii]

Hi all

A little issue I have been stuck on for many days now.

I have created a form with about 45 boxes to enter date. About 10 of these will be combo boxes that will look up data from certain tables(the user then selects the relevent choise). The rest of the boxes are all stnadard textboxes where the user enters certain info.

I also then have a save button on the bottom of the form.

What I need to happen is once the whole form has been completed and the user press Save, is for the form data to be saved to about four different tables. Now I cannot work out the easiest way to go about this. What I also want, is once the user has slected Save and during the write process, there is a problem, for a rollback operation to take place to remove data written to tables during execution, to be removed.

Hope this makes sense.

Thanks

We need much more information than you have provided here:
__1. Are the 4 Tables related?
__2. If they are, what are the relationships between them?
__3. What Fields are they related on and what are the Relationship types? (1 to 1, 1 to Many)?
__4. What is the underlying Record Source for the Form?
__5. Do these 10 Combo Boxes have Control Sources or are they all Unbound?
__6. etc., etc., etc.
__7. The 2nd part of your question involves encapsulating the entire Record writing process inside a Transaction. You are a long way from that without getting the other issue resolved first.

[bloukopkoggelmander]

Thank you for the reply.

Well unfotunately the table realtaionships are not as straight forward as it should be because I am using linked tables to a AS400 system and relationships does not work the same on AS400 as in access or SQL. (For one, you cannot use foreign keys on AS400) I have in all 48 tables and trying to relate these on the AS400 i some way is a nightmare.

There is no underlying recordsource for the form.

All the comboboxes that would be looking up data,(presented in a dropdown list) would be bound to various fields in many different tables.

This propable all sounds a bit complicated.

So to try and make things easier, I am more after just a point in the right direction, like do I use a extremely long SQL Insert statement? Or do I use an append Query? etc.