Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Link a contact to a Job file

Discussion in 'Information Technology' started by axelcore, Jul 28, 2006.

  1. axelcore

    Expand Collapse

    I have a fe be data base that i have set up. I have one form called
    *contacts* and another form called *jobcenter*. Right now i have the
    *contacts* form setup as a subform on the *jobcenter* form and *contacts*
    available as a stand alone form. This allows the user to add new contacts
    via the *contacts* form if it is not affiliated with a job, or they can open
    the *jobcenter* form go to the appropriate job and add the contact that way
    as well. Currently i have the customer name as the link between the job and
    the contact information so that only contact info for a certain customer
    shows up when you open a job for that customer. This works great, but i am
    running into the problem of big customers with multiple job sites showing up
    as contacts for jobs they are not affiliated with.

    The question is how do i link a contact to a job by clicking on a button on
    the job form and then choosing the appropriate contact to link to that job
    with a onclick event. I know that i could have a job number field for the
    contact and do it this way but i was hoping i could do it by browsing for the
    job number from the contact screen for the sake of user friendliness. Does
    anybody have any ideas of how to implement this?
  2. Loading...

    Similar Threads Forum Date
    Eh Janam Tumhare Lekhe... Official Movie Link... Announcements Jun 3, 2015
    Sikhism Complete Shalok Mehala 9 (Link) Videos Apr 22, 2014
    UK British PM orders probe into Thatcher link to Operation Bluestar (UPDATED) Breaking News Jan 14, 2014
    India Gwalior: A Unique Link to India's History Breaking News Nov 16, 2013
    Researchers establish link between racism and stupidity General Sep 28, 2013

Share This Page