Database form for inventory have issue in multi data insert

[jacksa]

I make database for inventory to used in my work but there is problem in I want to use one field to insert multi data to table using


If you lock at the form ( Attachment ) you will see serial field and MAC field

I want to input multi serial in one field Separated by anything like space,comma or line.

but when it go in table I want ever serial in separated record

can anyone help me

apology am not this good in English

Thanks for Everyone

 

[pr2-eugin]

You will need a bit of VBA (Not Recommended). How good are your VBA skills? If you would not want VBA, then you should restructure your DB to achieved this (Recommended)

 

[jacksa]

am good in VBA but am trying not to used because am not gone be in here so long and the person will come after me will suffers I want to make it so sample as I can.

If I don't found any way I will use VBA.

Thanks pr2-eugin for take time to reply

 

[AccessBlaster]

One question Jacksa. In your inventory can you have a single item with more than one serial number and more than one MAC Address?

I would think Form / Subform would be more flexible. You state that you want to make it easy on the person who takes over this database, well searching may be a challenge based on your current design.

Just my two cents.

 

[jacksa]

Hi AccessBlster
No we can't the Item is Devices every device had one serial and one MAC Address.
why the searching well be difficult ??

This is just the first step in the design there is a lot of thing I will but it in it like search bar,subform and Buttons .

 

[AccessBlaster]

I want to input multi serial in one field Separated by anything like space,comma or line.

but when it go in table I want ever serial in separated record

IMHO every serial numbers deserve their own (sub) record, tied to either an asset number and or purchase order number on the parent record.