Generate report for current input

[AunN]

Dear Programmers!!

I have a scenario in which through insert query i input some data into a table. Like i have a table customer, Transaction and Movies. There is many to many relationship between customer and movies. but the intermediate entity is transaction. Now one to many between customer and transaction and one to many between movies and transaction. As i insert data into transaction i want to generate automatic report for that particular input only. As it will show which movies are sold to customer. How can i implement this thing. I know how to insert sql query in VBA but after that to generate automatic report what should i do?

 

[pbaldy]

Presuming you have the key value this would work:

http://www.baldyweb.com/wherecondition.htm

 

[AunN]

It worked

 

[pbaldy]

Glad it worked for you.