Hi everyone, I have a rather simple dilemma but for some reason I cannot get this to work. Can someone help me out? I am creating a database for a crisis hotline where people call-in if they are feeling depressed, need someone to talk to, etc. In the database, I am tracking basic information -- date/time the person calls, the identity they choose to reveal to the hotline, medication the person may be taking, etc. One of the other things that needs to be tracked is each phone call that is received by the hotline. It is possible to receive multiple phone call by the same person as well as only receiving one call per person. The dilemma that I am having is that I have the basic information of the person on a main form and call history in a subform. I am trying to setup a macro where if I double-click on one of the call history entries a 2nd form open with a more detailed view of the call. I have the following setup: Basic Information ---------------------------------- Client ID ---- Primary key Call history table ------------------------------------- Call received ---> Primary Client ID ---> Foreign Key I am trying to filter for all entries where Client ID (foreign key) matches Client ID (primary key) in a macro. I have also tried to do this with the 2nd form which is open by the filtering option. Any ideas?
[Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
