create duplicate fields

[GregB]

Ok here is my situation.
When my users create an invoice there is a subform that is a continuous form
that is for the inventory related to the invoice.
Now for example, lets say the order contains 5 dell 383 computers. Normaly
the user would have to go through and populate all the fields in inventory 5
seperate times, even though they are all identical. There is a field that is
labled quantity and I would like it so that after the field is updated it
will create X(the amount the user typed into this field) amount of duplicate
iventory items.

*The reason that I need a new row for each is that each inventory item has a
unique serial number.
*Also note, that I tried to just highlighting the field and copying a
pasting. While this did create seperate inventory items, for some reason the
fields that I pasted were not being added into the total cost function I have
built in.

Thansk for your time!

 

[GregB]

I understand what you are saying and appreciate the time you took to respond.
I can see how you came to your conclusion, however my database has multiple
tables and multiple relations.

This is actually for a puchasing unit withing my company.
Each invoice has multiple items purchased.
I have an inventory and invoice table.
Each inventory item needs to be tracked and therefore thier serial number is
scanned into the inventory table when we recieve them.
Because we have to track each asset, each asset needs its own row within the
inventory table
This problem reverts back to my orginal question.

Let me know if you need any other info

Thanks again!