By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,409 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

How to design dynamic table (Unknown number of cells)

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.