Hi All,
Please could you assist?
I need to create a query to multiply records in a new table
After I have ordered a product that requires an expiry date and a batch number, i need to receive the product
If 2 was ordered, I need to receive 1 and 1 to be able to add the batch number and the expiry date
if 4 was ordered, i need to receive 1+1+1+1
How will I accomplish this?
Or am I approaching this from an incorrect angle?
Please could you assist?
I need to create a query to multiply records in a new table
After I have ordered a product that requires an expiry date and a batch number, i need to receive the product
If 2 was ordered, I need to receive 1 and 1 to be able to add the batch number and the expiry date
if 4 was ordered, i need to receive 1+1+1+1
How will I accomplish this?
Or am I approaching this from an incorrect angle?