Hi brothertse,
i am building a database in access 2007 to keep track of our communications with the developers.
i have put in the form 3 tabs:communication records tab,developer contacts tab &consultant contacts tab.
the communication records tab has lookup fields for the project, the consultant name and developer name.
i want whenever i select a consultant in the communication tab of the form and click the consultat contacts tab to get all the details of the contact person of that consultant.is it possible or there is a better alternative to design the database.
i am building a database in access 2007 to keep track of our communications with the developers.
i have put in the form 3 tabs:communication records tab,developer contacts tab &consultant contacts tab.
the communication records tab has lookup fields for the project, the consultant name and developer name.
i want whenever i select a consultant in the communication tab of the form and click the consultat contacts tab to get all the details of the contact person of that consultant.is it possible or there is a better alternative to design the database.