G
Greg McLandsborough
I am creating a project database, where Projects have Contacts any/all of
different Types, Contacts also have a number of Employees. A Contact
possibly being a
Client, A Supplier, Or a Third Party. The Contact Type Register contact has
a Project_ID, Contact_ID and Contact_Type_ID relating to Tables. I have
cascaded Forms (via Buttons made with the Wizard) from "Project Register"
"Contact Types" "Contacts" and "Employees"
The first question is in the setup of Contact_Type_Form, How do I insert the
current Project_ID for all entries made in the [Contact Type Register].
Should/can I Filter the Entries in the Contact_Type_Form so only Contacts
related to that client appear?
The second Question is on Database Design, any pointer would be greatly
appreciated. I can attach the file should anyone be interested in helping a
novice?
Regards
Greg
different Types, Contacts also have a number of Employees. A Contact
possibly being a
Client, A Supplier, Or a Third Party. The Contact Type Register contact has
a Project_ID, Contact_ID and Contact_Type_ID relating to Tables. I have
cascaded Forms (via Buttons made with the Wizard) from "Project Register"
"Contact Types" "Contacts" and "Employees"
The first question is in the setup of Contact_Type_Form, How do I insert the
current Project_ID for all entries made in the [Contact Type Register].
Should/can I Filter the Entries in the Contact_Type_Form so only Contacts
related to that client appear?
The second Question is on Database Design, any pointer would be greatly
appreciated. I can attach the file should anyone be interested in helping a
novice?
Regards
Greg