Hi everyone, hope you can help me with this one:
I have a database of products all individually serial numbered. Each serial number will over time have four entry's, Manufacturer to us, us to customer, customer to us, us to manufactuer.
I need to create a report which calls up a particular movement eg us to customer - which is straight forward enough - the problem comes in that the same report needs to show the preceding entry for the serial no as well, cant get my head round how to do it!!
Many thanks
Ed
I have a database of products all individually serial numbered. Each serial number will over time have four entry's, Manufacturer to us, us to customer, customer to us, us to manufactuer.
I need to create a report which calls up a particular movement eg us to customer - which is straight forward enough - the problem comes in that the same report needs to show the preceding entry for the serial no as well, cant get my head round how to do it!!
Many thanks
Ed
