Saving data to tables?!

[cjmcfg]

I have a database which houses both an employee table(that has employee names, SS#, commission %, branch, etc) and another table that is used to enter loan information and the employee is selected that has assisted the customer. In a form I have a combo box referencing the employee table to bring forward Firstname, Lastname, branch, commision%, and SS#. From there i need to write all this data to a different table automatically dependent on the employee selected from the combo box. I used the =""&Employee.Column(1) function to call the data into text fields that i need written to table but it will not save any of the data in these fields or in fields below that calculate formulas such as yield and commission. How to do have the fields have into my tables?

 

[PHV]

Only controls bound to fields are automaticallay saved to the form's underlaying table(s).
So, a common way is to set the Value property of the calculated/derived control in the AfterUpdate event procedure(s) of the control(s) involved in the expression.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cjmcfg]

I know what you mean and where to find it but i have no clue on how to format the command to save to a specific field in the table...could you tell me or give me a resource that could?

 

[PHV]

You don't save directly to a specific field in the table but set the value of a control bound to this field.
i.e. the ControlSource property of the control is the name of the field instead of an expression.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cjmcfg]

so...where do i put my expression/reference equation?

 

[PHV]

In the AfterUpdate event procedure of the relevant controls (or the BeforeUpdate event procedure of the form after the check of all the validation rules).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cjmcfg]

for any of my fields if i paste this

="" & Officer.Column(5)

into updateafter and change the control source back to its original value "SS#", "Commission%", etc it just gives me a blank field and posts nothing?

 

[PHV]

In the Officer's AfterUpdate event procedure (click the ellips (...)) put something like this:
Me![Firstname] = Me!Officer.Column(0)
Me![Lastname] = Me!Officer.Column(1)
Me![branch] = Me!Officer.Column(2)
Me![commision%] = Me!Officer.Column(3)
Me![SS#] = Me!Officer.Column(4)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cjmcfg]

Still no Value

 

[PHV]

Still no Value
Even when you choose a different officer in the combo ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cjmcfg]

correct

 

[PHV]

What is the SQL code of the RowSource property of the combo and the WHOLE code of its AfterUpdate event procedure ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[lespaul]

So you want to take all that information about the employee and store it in a different table? Why not just store the PK of the employee table in the second table as a FK?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins