Running Queries From the Log Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Running Queries From the Log Table

Mark Fannin

13 months ago

I have an orderT and started using an orderLogT to track changes over time. I'm using the after update event to copy into the orderLogT. Now that I have a lot of data, what relationship should I set up between the orderT and orderLogT? The orderT has helper tables relating customer names and such. Only the orderT has a primary key, orderLogT has a related field as a number only - just like in Richard's video on track changes. What is the best method to create queries? Use the orderLogT and make new relationships with the helper tables?

	Juan Rivera @Reply 13 months ago
this happened to me some time ago i found that in my querry i was calling a field 2 times took some time to find it but but after I removed it worked fine. may not be the same with you but just in case double check to see if you are calling it 2 times?

Mark Fannin OP @Reply

13 months ago

Thank you Juan for the help. I will keep a sharp eye out for that. I worked some more on the problem last night and I think I need to add multiple instances of the employeeT to match each field where there are number values leading back to the employeeT. I recall Ricard mentioning in one of his classes where he added another instance of a table but I cannot recall which video it was. Any tips would be appreciated. All the best. Mark.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View