Transaction Journal With Two Tables

[spoiledbrat]

I have a form based on query. The query is based on two tables. In my form, I have a field called "Company Id" and another field called "Branch Name". Currently, when you enter a new record and you type in the Company ID, the Branch Name is pulled up automatically. I am now using a transaction journal in the form to automatically track any changes to any records into a table. Now, when you type in the Company ID, the Branch Name does not automatically fill in, however, when you close the form and open it again, the Branch Name is filled in. Does anyone know how I can alter the coding for the transaction journal so that it can work for two tables. I used the example in the help section.

Thanks

 

[MichaelRed]

check faq181-291 for a 'home-brew' version of transaction logging. It is set up for a single table, but it really doesn't matter, as it is only loggong the Form field name.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over