2 queries in one form (2 Viewers)

[TMK]

What is the user using as a reference document? A piece of paper? A pdf or excel file? Something else?

And why not use a continuous form?

Or a main form to capture delivery details and continuous subform to capture product details?

yes my plan was t use a continous form, but it shows me all the old records aswell, i want jus the records only, the ref doc is a printed paper from the factory

 

[TMK]

the s

It is easy to create a loop to add "10" records. The problem is that each record needs to have a serial number associated with it. If the items come to you with sequential serial numbers, you can ask for a starting value and increment that. I'm very confused. Which will be the official "serial number"? The one on the non-removable label on the item or the one you are generating?

erial number would be a number generated by the system which is in sequncial order 1 to 100 and so on

 

[TMK]

Please clarify.

Is it the case that you actually have two different "Codes"?

That is what this paragraph suggests.

1. "...the item code is a hardcode[d] id from the factory itself..."
2. "...the serial unique id case comes up only when stock is added to the shelve.."

Please confirm: Is there a manufacturer's code and also your own inventory code?

If so, I assume (hope, actually) that you have two different fields for each of these codes in the Product table.

And further, I assume that you are only struggling with your own, unique, serial ID which you create for each item as it is added to your inventory? The existence of a separate manufacturer's code is, therefore, a distraction, is it not? Or is it somehow involved in your attempt to create and manage unique serial numbers?

As others have suggested, there are multiple ways to handle this, from list boxes to continuous forms to coding solutions.
I am not yet clear on what needs to be done, exactly.

yes two different fields, ill share the sample file i made shortly.
and yes i am having a hard time with my own ID which is created to identify each record created when a new stock is added to inventory

 

[TMK]

heres the sample