Could someone please please help me with this.
I have 2 tables
The first one is called "tblCompany" and holds various information about companies such as "Company Name","Postcode" etc.
The second is called "tblContact" and holds information such as "Contact Name" and "Company Name". The "Company Name" field in this table is a combo box which looks up the values stored in the table "tblCompany" under the field "Company Name".
I then have a form which includes 2 combo boxes, the first combo box (which I shall call "ctrlCompanyName" displays values stored in the table "tblCompany" and from the field "Company Name". Now depending on what Company is selected in this first combo box the second combo box (which I call "ctrlContactName") displays a list of peoples names.
What I need to be able to do is if a user trys to input data into the "ctrlContact Name" combo box and the value they enter is not in the list I need to automatically update the table "tblContact" with the new contact name and the value they chose from the 1st combo box ("ctrlCompany Name")
I hope this makes sense.
Thanks in advance for any help anybody can give me on this.
Steven.
I have 2 tables
The first one is called "tblCompany" and holds various information about companies such as "Company Name","Postcode" etc.
The second is called "tblContact" and holds information such as "Contact Name" and "Company Name". The "Company Name" field in this table is a combo box which looks up the values stored in the table "tblCompany" under the field "Company Name".
I then have a form which includes 2 combo boxes, the first combo box (which I shall call "ctrlCompanyName" displays values stored in the table "tblCompany" and from the field "Company Name". Now depending on what Company is selected in this first combo box the second combo box (which I call "ctrlContactName") displays a list of peoples names.
What I need to be able to do is if a user trys to input data into the "ctrlContact Name" combo box and the value they enter is not in the list I need to automatically update the table "tblContact" with the new contact name and the value they chose from the 1st combo box ("ctrlCompany Name")
I hope this makes sense.
Thanks in advance for any help anybody can give me on this.
Steven.
