dbTalk Databases Forums  

help getting started

comp.database.ms-access comp.database.ms-access


Discuss help getting started in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DBLEXPOSURE
 
Posts: n/a

Default help getting started - 12-10-2007 , 11:50 AM






A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to choose
from. Box2 - 4 would then need to be relevant to what was selected in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...




Reply With Quote
  #2  
Old   
Patyrick Fisher
 
Posts: n/a

Default Re: help getting started - 01-08-2008 , 04:51 PM






Yoiu need to think about having a category field in each of your
tables this will enable you to control the output based on the
selection.
Cheers
Patrick

On Mon, 10 Dec 2007 11:50:31 -0600, "DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com>
wrote:

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to choose
from. Box2 - 4 would then need to be relevant to what was selected in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...




Reply With Quote
  #3  
Old   
Patyrick Fisher
 
Posts: n/a

Default Re: help getting started - 01-08-2008 , 04:51 PM



Yoiu need to think about having a category field in each of your
tables this will enable you to control the output based on the
selection.
Cheers
Patrick

On Mon, 10 Dec 2007 11:50:31 -0600, "DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com>
wrote:

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to choose
from. Box2 - 4 would then need to be relevant to what was selected in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...




Reply With Quote
  #4  
Old   
Patyrick Fisher
 
Posts: n/a

Default Re: help getting started - 01-08-2008 , 04:51 PM



Yoiu need to think about having a category field in each of your
tables this will enable you to control the output based on the
selection.
Cheers
Patrick

On Mon, 10 Dec 2007 11:50:31 -0600, "DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com>
wrote:

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to choose
from. Box2 - 4 would then need to be relevant to what was selected in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...




Reply With Quote
  #5  
Old   
Patyrick Fisher
 
Posts: n/a

Default Re: help getting started - 01-08-2008 , 04:51 PM



Yoiu need to think about having a category field in each of your
tables this will enable you to control the output based on the
selection.
Cheers
Patrick

On Mon, 10 Dec 2007 11:50:31 -0600, "DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com>
wrote:

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to choose
from. Box2 - 4 would then need to be relevant to what was selected in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...




Reply With Quote
  #6  
Old   
Andy Roberts
 
Posts: n/a

Default Re: help getting started - 06-18-2008 , 08:01 PM



Try here...

http://www.fontstuff.com/access/acctut10.htm

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
"DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com> wrote

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to
choose from. Box2 - 4 would then need to be relevant to what was selected
in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...






Reply With Quote
  #7  
Old   
Andy Roberts
 
Posts: n/a

Default Re: help getting started - 06-18-2008 , 08:01 PM



Try here...

http://www.fontstuff.com/access/acctut10.htm

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
"DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com> wrote

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to
choose from. Box2 - 4 would then need to be relevant to what was selected
in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...






Reply With Quote
  #8  
Old   
Andy Roberts
 
Posts: n/a

Default Re: help getting started - 06-18-2008 , 08:01 PM



Try here...

http://www.fontstuff.com/access/acctut10.htm

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
"DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com> wrote

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to
choose from. Box2 - 4 would then need to be relevant to what was selected
in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...






Reply With Quote
  #9  
Old   
Andy Roberts
 
Posts: n/a

Default Re: help getting started - 06-18-2008 , 08:01 PM



Try here...

http://www.fontstuff.com/access/acctut10.htm

--
Regards

Andy
___________
Andy Roberts
Win XP Pro
Access 2007
"DBLEXPOSURE" <pzig98 (AT) hotmail (DOT) com> wrote

Quote:
A little push in the right direction.

I want to set up a form for data entry with 3 or 4 combo boxes. box one
would be driven by a table that contains the options I want people to
choose from. Box2 - 4 would then need to be relevant to what was selected
in box1.

i.e. If the user selects "Hat" in box1 then I need box2 to show,
cowboy,baseball,stocking... and box three to show size7,8,9...

But if the user selects Wrench in box1 the box2 should show,
crescent,open-end,socket... and box3 should show what is relevant to what
was selected in box1 and 2...






Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.