That is not a capability of data merge.
Perhaps you could explain this in more detail and including the version if InDesign that you have would also be a good idea.
thanks for your response, im using indesing CS6 to give more detail we have 4000 products in our range we want to create a template that we can export to PDF so that when a product code is selected from a dropdown list the LOT, Expiry and box quanities are populated from the background data.
Any suggestions will be a great help
That is not what data merge does. Think about it more along the lines of a mail merge.
I think you’re going to need to do this in Acrobat at a minimum and perhaps even LiveCycle.
I’d pop over to the Acrobat forum and see if anyone there has any scripts to help automate this.
Thanks for your help Bob, will head over the the acrobat forum and see if there are any solutions to be found there.