Insert a table data to another table. (1 Viewer)

[smtazulislam]

Hello everyone !
I have a table "tblEmployee". it is INNER JOIN with table "tblContracts" by EmployeeID.

I would like when I enter the employmentDATE then it insert date into the table tblContracts in DATEFROM field. also appending this same EmployeeID within others 4 fields LIKE :
EmployeeID = Same entered
ContractType = "First Contract"
DATEEND = ""
State = "Request Pending"

with condition : If EmployeeID is not already present in tblContracts then ignore Appending

 

[June7]

Can each employee have multiple contract records? You want to create a new contract record?

Is DATEEND a date/time field? If so, cannot set to empty string.

 

[smtazulislam]

Can each employee can have multiple contract records? You want to create a new contract record?

Yes, Each employee have multiple contract. That why, I want to condition if tblContract.EmployeeID is present then Ignored to append.

Is DATEEND a date/time field? If so, cannot set to empty string.

Yeah, DateEnd filed is set Date/Time.

 

[June7]

Are you running code behind form bound to tblEmployee?

Do a lookup on tblContract to see if employee record exists.

 

[smtazulislam]

Are you running code behind form bound to tblEmployee?

Form frmEmployeeEdit under the TAB Control page in subform "sfrmContract"

Do a lookup on tblContract to see if employee record exists.

Yeah, in subform ContractType field have droplist. But not lookup in the table tblContracts.