Jump to content

Help on understanding Arrays


kenwvs

Recommended Posts

I am hoping someone will be inclined to explain to me how array's work and what type of array I would use.  I have a book that i was reading up on array's but it talks about all the different kinds of arrays and now I am confused.

I have a table that was working but I have done some database normilization and now I need to change things around a bit. 

I have 7 fields in a form to list a part number (they were called part 1, part 2, etc.) and then I have 7 more fields for a parts description (they were called number 1, number2, etc.).  In my database I have a column called part and another column called number.  I need to create a query where it will insert the data from the 2 fields into the DB, but not add any empty rows if there weren't 7 part numbers or descriptions.

I was told to use an array to do this, but I am lost on this, and haven't been able to google anything that really explains (in noobie terms) how an array works or how to set it up.

I appreciate any help

Ken
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.