How to design dynamic table (Unknown number of cells)

[E.U.]

Hi,

I an using MS-Access in order to build a site.
I have this item that can have upto 10 pictures (might have none)
I want to design a dynamic table which has the ID of the item at the
first cell (primary key) and then upto 10 cells of file names of the
pictures.

The problem is that I do not know in advance how much pictures will I
have (since it depends of each item that is added)
What should I do? Do I have to make all the cells in advance with a
default value and if I dont put any picture just don't use them?
(seems like a big waste of memory)

Can you please guide me about my options? (I am using the "Create by
design view" in order to create a table)

Thanks in advance

[Douglas J. Steele]

I'd advise looking into database normalization. Then you'd realize that what
you're trying to do isn't recommended. Instead of multiple fields in a
single row, you should have multiple rows.

Here are a bunch of references I have handy, but I can't guarantee they're
all still valid:

Normalization:
http://www.webmasterbase.com/article.php/378
http://www.jpmartel.com/bu12_c.htm (aimed at dBase, but still valid)
ACC2002: Database Normalization Basics (Q283878)
http://support.microsoft.com/?id=283878
ACC2000: Database Normalization Basics (Q209534)
http://support.microsoft.com/?id=209534
ACC: Database Normalization Basics (Q100139)
http://support.microsoft.com/?id=100139

http://home.earthlink.net/~billkent/Doc/simple5.htm
http://www.sbpa.csusb.edu/flin/info6...gn/Default.htm
http://www.northern.ac.uk/computing_...mal/03-1nf.htm
http://burks.bton.ac.uk/burks/foldoc/35/28.htm
Fundamentals of Relational Database Design
http://support.microsoft.com/?id=129519
Understanding Relational Database Design
http://support.microsoft.com/?id=234208
Database Design Principles
http://msdn.microsoft.com/library/de...stemObject.htm
Understanding Relational Database Design (downloadable Word doc)
http://support.microsoft.com/?id=164172
Fundamentals of Relational Database Design
http://www.microsoft.com/technet/Acc...note/ac101.asp
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"E.U." <el******@gmail.com> wrote in message
news:c2**************************@posting.google.c om...

Hi,

I an using MS-Access in order to build a site.
I have this item that can have upto 10 pictures (might have none)
I want to design a dynamic table which has the ID of the item at the
first cell (primary key) and then upto 10 cells of file names of the
pictures.

The problem is that I do not know in advance how much pictures will I
have (since it depends of each item that is added)
What should I do? Do I have to make all the cells in advance with a
default value and if I dont put any picture just don't use them?
(seems like a big waste of memory)

Can you please guide me about my options? (I am using the "Create by
design view" in order to create a table)

Thanks in advance