multiselction/subforms

[hcwanton]

Unfortuantley I have been trying to create a printer cartridge inventory
system for some time now and cant seem to get it to work. basically this is
what I want- I want to enter in the bar code from the cartridge with a
barcode scanner (which works fine)- I then want to enter quantity amount on
hand and such- I also want to be able to enter in what printer(s) the
cartridge goes to -which after reading I found that I should not create a
list box based on a printer table because although I could set it up to
multiselect I could not return more than one value in the table nor would it
be proper to. I also want information to be held on each cartridge as to when
we have ordered (date and quantity) and when we rec'd (date and quantity) ok
so I already have a copy of the northwinds database and basically the orders
forms/database is what I want but i still cant get it!! . I currently have 4
tables one for the cartriges with a (cartridgeID as a PK) i have a printer
table which lists all the printers with a field (cartridgeId) and a table in
which would be the join table to join this information as well as a order
details table that again based on the cartridgeId should all be linkable.I
understand that I would create a form (cartridge) then a form to select the
appropriate printers associated to this cartridge that would update this new
join table -but that is where I am stuck how to I bring this new table in
which the information from both tables are dumped in?????????

 

[Steve]

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter (Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and the
subform is based on TblPrinter. With a form/subform you can enter cartridges
and printers at the same time. You would enter a cartridge record then enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select a
printer on the main form and the subform will display all the printers that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[hcwanton via AccessMonster.com]

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to be on
hand, and what printers the cartridges are assigned to. I thought I needed
the join table to hold the multiple printers that one cartridge could have
and printers can have more than one cartridge(as far as color or black)-. I
do have a form to add new cartridges -which is where I wanted to add the
option to choose which printers go with that cartridge. and a form to add
new printers. Where are the multiple printers stored??? it would be a subform
for the tblcartridge right? I also need then another subform linked to the
tblcartridge that would give me order details as to when a order was placed
for new how many etc.... thanks- for your quick response-I really dont know
why I am having such a hard time understanding this- I was origianlly looking
to buy software to do this but what I need seemed to be to be so basic. but
at this rate I should have just bought one.

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter (Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and the
subform is based on TblPrinter. With a form/subform you can enter cartridges
and printers at the same time. You would enter a cartridge record then enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select a
printer on the main form and the subform will display all the printers that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Unfortuantley I have been trying to create a printer cartridge inventory
system for some time now and cant seem to get it to work. basically this

[quoted text clipped - 26 lines]

join table -but that is where I am stuck how to I bring this new table in
which the information from both tables are dumped in?????????

 

[Steve]

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to be
on
hand, and what printers the cartridges are assigned to. I thought I needed
the join table to hold the multiple printers that one cartridge could have
and printers can have more than one cartridge(as far as color or black)-.
I
do have a form to add new cartridges -which is where I wanted to add the
option to choose which printers go with that cartridge. and a form to
add
new printers. Where are the multiple printers stored??? it would be a
subform
for the tblcartridge right? I also need then another subform linked to the
tblcartridge that would give me order details as to when a order was
placed
for new how many etc.... thanks- for your quick response-I really dont
know
why I am having such a hard time understanding this- I was origianlly
looking
to buy software to do this but what I need seemed to be to be so basic.
but
at this rate I should have just bought one.

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter (Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and the
subform is based on TblPrinter. With a form/subform you can enter
cartridges
and printers at the same time. You would enter a cartridge record then
enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select
a
printer on the main form and the subform will display all the printers
that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Unfortuantley I have been trying to create a printer cartridge inventory
system for some time now and cant seem to get it to work. basically this

[quoted text clipped - 26 lines]

join table -but that is where I am stuck how to I bring this new table
in
which the information from both tables are dumped in?????????

 

[John W. Vinson]

If you want to buy software, I'll create the database for you for $150.

Or the other volunteers here on the newsgroup - the vast majority who don't
misuse the forum to solicit business - will help you develop one yourself, for
free.

I'd get some previous customer comments if I were you. Make sure they're not
Steve's "sock puppets".

John W. Vinson [MVP]

 

[John Marshall, MVP]

So steveO, you do not consider this soliciting?

These newsgroups are for FREE peer to peer support.

John... Visio MVP

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to
be on
hand, and what printers the cartridges are assigned to. I thought I
needed
the join table to hold the multiple printers that one cartridge could
have
and printers can have more than one cartridge(as far as color or black)-.
I
do have a form to add new cartridges -which is where I wanted to add the
option to choose which printers go with that cartridge. and a form to
add
new printers. Where are the multiple printers stored??? it would be a
subform
for the tblcartridge right? I also need then another subform linked to
the
tblcartridge that would give me order details as to when a order was
placed
for new how many etc.... thanks- for your quick response-I really dont
know
why I am having such a hard time understanding this- I was origianlly
looking
to buy software to do this but what I need seemed to be to be so basic.
but
at this rate I should have just bought one.

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter
(Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and
the
subform is based on TblPrinter. With a form/subform you can enter
cartridges
and printers at the same time. You would enter a cartridge record then
enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select
a
printer on the main form and the subform will display all the printers
that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Unfortuantley I have been trying to create a printer cartridge
inventory
system for some time now and cant seem to get it to work. basically
this
[quoted text clipped - 26 lines]
join table -but that is where I am stuck how to I bring this new table
in
which the information from both tables are dumped in?????????

 

[John Marshall, MVP]

So steveO, you do not consider this soliciting?

These newsgroups are for FREE peer to peer support.

John... Visio MVP

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to
be on
hand, and what printers the cartridges are assigned to. I thought I
needed
the join table to hold the multiple printers that one cartridge could
have
and printers can have more than one cartridge(as far as color or black)-.
I
do have a form to add new cartridges -which is where I wanted to add the
option to choose which printers go with that cartridge. and a form to
add
new printers. Where are the multiple printers stored??? it would be a
subform
for the tblcartridge right? I also need then another subform linked to
the
tblcartridge that would give me order details as to when a order was
placed
for new how many etc.... thanks- for your quick response-I really dont
know
why I am having such a hard time understanding this- I was origianlly
looking
to buy software to do this but what I need seemed to be to be so basic.
but
at this rate I should have just bought one.

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter
(Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and
the
subform is based on TblPrinter. With a form/subform you can enter
cartridges
and printers at the same time. You would enter a cartridge record then
enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select
a
printer on the main form and the subform will display all the printers
that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Unfortuantley I have been trying to create a printer cartridge
inventory
system for some time now and cant seem to get it to work. basically
this
[quoted text clipped - 26 lines]
join table -but that is where I am stuck how to I bring this new table
in
which the information from both tables are dumped in?????????

 

[John Marshall, MVP]

So steveO, you do not consider this soliciting?

These newsgroups are for FREE peer to peer support.

John... Visio MVP

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to
be on
hand, and what printers the cartridges are assigned to. I thought I
needed
the join table to hold the multiple printers that one cartridge could
have
and printers can have more than one cartridge(as far as color or black)-.
I
do have a form to add new cartridges -which is where I wanted to add the
option to choose which printers go with that cartridge. and a form to
add
new printers. Where are the multiple printers stored??? it would be a
subform
for the tblcartridge right? I also need then another subform linked to
the
tblcartridge that would give me order details as to when a order was
placed
for new how many etc.... thanks- for your quick response-I really dont
know
why I am having such a hard time understanding this- I was origianlly
looking
to buy software to do this but what I need seemed to be to be so basic.
but
at this rate I should have just bought one.

Do your tables look like:
TblCartridge
CartridgeID
<<Fields about a cartridge>>

TblPrinter
PrinterID
CartridgeID
<<Fields about a printer>>

You don't need a junction table since there is only one cartridge in a
printer. I don't know what your orders detail table is for!!

You can enter data in the two tables above in two ways:
1A. A form to enter cartridges in TblCartridge
1B A form to enter Printers and their cartridges in TblPrinter
(Requires
1A o be done first)
2. A form/subform where the main form is based on TblCartridge and
the
subform is based on TblPrinter. With a form/subform you can enter
cartridges
and printers at the same time. You would enter a cartridge record then
enter
all printer records for the printers that use that cartridge. After data
entry is complete, the form subform is very useful in that you can select
a
printer on the main form and the subform will display all the printers
that
use that cartridge.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Unfortuantley I have been trying to create a printer cartridge
inventory
system for some time now and cant seem to get it to work. basically
this
[quoted text clipped - 26 lines]
join table -but that is where I am stuck how to I bring this new table
in
which the information from both tables are dumped in?????????

 

[Robert Morley]

Apparently someone does, because I never got that message.



Rob

 

[hcwanton via AccessMonster.com]

Im not going to give up yet I am going to try and focus on the tables and
relationships first then worry about the forms. I think i may have the
relationships not correct and that may be a big reason for my errors.

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to be

[quoted text clipped - 58 lines]

 

[tina]

good for you! the best way to learn is to work through issues yourself (with
or without help <g>); and you're taking a very good approach to re-examine
your tables/relationships. many of the questions and problems pertaining to
queries, forms, and reports, that are posted in these newsgroups, are
actually caused by poor relational design.

hth

Im not going to give up yet I am going to try and focus on the tables and
relationships first then worry about the forms. I think i may have the
relationships not correct and that may be a big reason for my errors.

If you want to buy software, I'll create the database for you for $150.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Yes my tables do look like that The database is actually created for the
cartridges -to keep track of which ones are in stock, what is needed to

be
[quoted text clipped - 58 lines]

in
which the information from both tables are dumped in?????????

 

[hcwanton via AccessMonster.com]

what has surprised me is how much of a hard time I am having with this I have
created many I guess simple database with alot of extra stuff ex pop up
calendar, using the not in list event and such but this is the first time I
wanted to create a database in which a field for example type of printer can
be more than one. And I want to use be able to view the database to show
transactions like how many ordered rece etc. So do I need a junction table?
my cartridge can have multiple printers and the printer can have multiple
printers. so I am assuming I need to create a many to many for both of these
table that link to a junction table?

good for you! the best way to learn is to work through issues yourself (with
or without help <g>); and you're taking a very good approach to re-examine
your tables/relationships. many of the questions and problems pertaining to
queries, forms, and reports, that are posted in these newsgroups, are
actually caused by poor relational design.

hth

Im not going to give up yet I am going to try and focus on the tables and
relationships first then worry about the forms. I think i may have the

[quoted text clipped - 11 lines]

 

[pietlinden]

Or the other volunteers here on the newsgroup - the vast majority who don't
misuse the forum to solicit business - will help you develop one yourself, for
free.

I'd get some previous customer comments if I were you. Make sure they're not
Steve's "sock puppets".

John W. Vinson [MVP]

Here's a comment... not sure it's from a customer, though....

http://groups.google.com/group/comp...=gst&q="Stop+STeve"+NL&rnum=4#4fb7c62bbb463b7

 

[tina]

there's no true shortcut to learning relational design principles, hon. it
takes an investment of time and energy; and like anything else we try to
learn in life, it takes longer for some to grasp the essentials than others.
but this is very much an issue of "where you end up", NOT "how long it took
you to get there". i really encourage you to step back from your database
and put some time into studying relational design, then come back to it
fresh and i believe you'll be able to answer your own questions with some
confidence. at that point, you can post your tables/relationships structure
in the microsoft.public.access.tablesdbdesign ng and ask for feedback, if
you wish. suggest you take a look at the following link:
http://home.att.net/~california.db/tips.html.

hth

what has surprised me is how much of a hard time I am having with this I have
created many I guess simple database with alot of extra stuff ex pop up
calendar, using the not in list event and such but this is the first time I
wanted to create a database in which a field for example type of printer can
be more than one. And I want to use be able to view the database to show
transactions like how many ordered rece etc. So do I need a junction table?
my cartridge can have multiple printers and the printer can have multiple
printers. so I am assuming I need to create a many to many for both of these
table that link to a junction table?

good for you! the best way to learn is to work through issues yourself (with
or without help <g>); and you're taking a very good approach to re-examine
your tables/relationships. many of the questions and problems pertaining to
queries, forms, and reports, that are posted in these newsgroups, are
actually caused by poor relational design.

hth

Im not going to give up yet I am going to try and focus on the tables and
relationships first then worry about the forms. I think i may have the

[quoted text clipped - 11 lines]

in
which the information from both tables are dumped in?????????