How can I make certain form fields populate automatically?

[Booshay]

Although seasoned in IT networking, I'm fairly new to database design.

The database I'm constructing currently has 2 tables - a customer info table
and a sales rep table. The customer table contains generic customer info
fields gathered from an application form. The sales rep table contains what I
would consider static data - a salespersons name, their Rep ID, and their
Branch ID.

In my data entry form, I'd like for the Rep ID and Branch ID fields to
populate automatically when the data entry person selects a salespersons name
from a drop down.

It sounds like a simple concept, yet I've been unable to put my finger on
exactly how to do this. This project is still in its infancy stage so I'm not
married to any of the design I currenty have. Any suggestions greatly
appreciated.

Not enough info?

 

[Golfinray]

Try taking a look at www.fontstuff.com because Martin Green has some good
stuff on multiselect boxes. Also try Allen Browne at www.allenbrowne.com

BUT, the basic way to get a search function is to go into the afterupdate
event of a combo box you add to your form, start the code builder, and type:
Me.filter = "[salesrep] = """ & Me.combo# & """"
Me.filteron=true
Combo# will be listed, like combo7 or combo20. Hope any of this helps. Ray

 

[Booshay]

Thanks! I'm laughing now cuz I made my way to the code builder from my field
but I had NO IDEA what to do next.

I'll be sure to check out those two sites - thanks for the tip.

I have a few books on order that should be arriving tomorrow - can't wait to
pursue this further.

Try taking a look at www.fontstuff.com because Martin Green has some good
stuff on multiselect boxes. Also try Allen Browne at www.allenbrowne.com

BUT, the basic way to get a search function is to go into the afterupdate
event of a combo box you add to your form, start the code builder, and type:
Me.filter = "[salesrep] = """ & Me.combo# & """"
Me.filteron=true
Combo# will be listed, like combo7 or combo20. Hope any of this helps. Ray

Although seasoned in IT networking, I'm fairly new to database design.

The database I'm constructing currently has 2 tables - a customer info table
and a sales rep table. The customer table contains generic customer info
fields gathered from an application form. The sales rep table contains what I
would consider static data - a salespersons name, their Rep ID, and their
Branch ID.

In my data entry form, I'd like for the Rep ID and Branch ID fields to
populate automatically when the data entry person selects a salespersons name
from a drop down.

It sounds like a simple concept, yet I've been unable to put my finger on
exactly how to do this. This project is still in its infancy stage so I'm not
married to any of the design I currenty have. Any suggestions greatly
appreciated.

Not enough info?