Field populating from other table n preserve

[Haseeb]

Hi

I have table "Job Profile"(ID, fkId_Classification, "Salary From", "Salary To"...)

and Classification(ID[pk], Classification, From, To)

My goal is to pick a Classfication from a Drop down list and populates the "Job Profile":"Salary From" n "Salary To" from Classification:From n To.

Now the Classification table will be updated from time to time when new salary scales are proposed. But do not want the old "Job Profile" records to be updated. When it is committed its done.

New Salary scale(From n To) will only reflect on new records.

So to do that what I should do.

[Haseeb]

Absolutely perfect answer.

I got what I wanted.

Actually From To fields are for Salary range i.e. From $51000 to $58000.

Thanks a lot.

Haseeb