help with distribution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bigwillno2 - 17 Dec 2007 18:43 GMT

I created couple of tables for a mattress database, the tables are not size
(twin, full, queen) specific, and i am doing this because, new mattresses are
created frequent and what i like to do, if i was to enter a part, i like my
system to distribute it by sizes, this way, i dont enter a part for every
size of mattress. do anyone, know, or seen something similar and can someone
direct me to someone that knows...or a database similar to this.

Reply to this Message

Jeanette Cunningham - 17 Dec 2007 21:30 GMT

Hi

Have a look at the templates for Access databases on the microsoft webiste.
These will give some ideas on how to set up a database.

Jeanette Cunningham

>I created couple of tables for a mattress database, the tables are not size
> (twin, full, queen) specific, and i am doing this because, new mattresses
[quoted text clipped - 5 lines]
> someone
> direct me to someone that knows...or a database similar to this.

Reply to this Message

John W. Vinson - 17 Dec 2007 22:50 GMT

>I created couple of tables for a mattress database, the tables are not size
>(twin, full, queen) specific, and i am doing this because, new mattresses are
>created frequent and what i like to do, if i was to enter a part, i like my
>system to distribute it by sizes, this way, i dont enter a part for every
>size of mattress. do anyone, know, or seen something similar and can someone
>direct me to someone that knows...or a database similar to this.

I'm not sure what you mean by "distribute". How are your tables related? When
you enter a part, what table or tables are you entering it into, and what do
you want to happen? Do you want to create a record for every existing mattress
record... and if so, why?

John W. Vinson [MVP]

Reply to this Message