If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How can I make certain form fields populate automatically?
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? |
#2
|
|||
|
|||
How can I make certain form fields populate automatically?
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" wrote: 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? |
#3
|
|||
|
|||
How can I make certain form fields populate automatically?
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. "Golfinray" wrote: 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" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|