PC Review


Reply
Thread Tools Rate Thread

Auto-classify a selection

 
 
Allison
Guest
Posts: n/a
 
      5th Mar 2009
I posted this over on formscoding, but didn't get a response. I'm reposting
here in hopes maybe this is the right forum. Thanks.

Access 2003, XP Srvc Pack 3

I want to automatically classify an entry based on its selection.

Details so far:

tblContact (contains standard info about the contact)
tblContactType (an ID# field and description [classifications for the
contact such as vendor, employee, etc.])
tblComboContactType (contains the ID# for each combination of contact and
type. Example fldComboContactID, fldContactTypeID, fldContactID)
tblMaster (contains info about each company)

Usually to populate the tblComboContactType I tie the main form to the
"Contact" table, the subform to the "ComboContactType" table, and use the
"ContactType" as the row source for a combo box. This works fine.

I want to create an entry form to capture which contacts can authorize
purchases on behalf of a given company.

What I'd like to do on the form is select the company (I know how to do this
part), present a combo box with entries for each contact associated with that
company (pretty sure I can do this), then have the combination of
contact/"fact that they can sign" (this is a unique contact type called
"signer") populate into my tblComboContactType (this is the part I don't know
how to do).

Any suggestions or pointers to figure out how to do this?

Thank you for your help.

Allison
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
classify Miriam Microsoft Access Queries 4 8th Dec 2009 09:17 PM
Classify an entry based on its selection Allison Microsoft Access Form Coding 0 3rd Mar 2009 11:01 PM
Classify grups Tiiii Microsoft Excel Worksheet Functions 2 23rd Sep 2008 02:11 PM
Classify in categories =?Utf-8?B?Sm95Y2U=?= Microsoft Excel Misc 4 20th Oct 2006 11:55 AM
Unsure where to classify this =?Utf-8?B?QmlnZ2xlcw==?= Microsoft Access VBA Modules 1 16th Aug 2005 02:16 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:02 PM.