How do I get copied information saved within another table?

[REAPER_110]

ok will mark as solved. One more question please?

I forgot to mention I did experience as follows:-

tblExperience
-pkExpID
-fkClientInterviewID
-txtDirectExp
-txtTransExp
-fkWorkExpLvl

tblWorkLvl
-pkWorkExpLvl
-LvlID
-txtLevel

Does the structure of that look ok??

Is it ok to keep you posted on how I am doing??



Kind Regards,
Andrew.

[jzwp11]

Since experience is still experience whether it is direct or transferable, I would just have 1 field to record the experience and then another field that says what type (direct or transferable).

tblExperience
-pkExpID
-fkClientInterviewID
-txtExperience
-ExperienceType
-fkWorkExpLvl

If you anticipate that you may have other types of experience in the future, you could consider having a table of types and then reference it with a foreign key in the experience table

tblExperience
-pkExpID
-fkClientInterviewID
-txtExperience
-fkExperienceTypeID foreign key to tblExperienceTypes
-fkWorkExpLvl

tblExperienceType (2 records for now: direct, transferable)
-pkExperienceTypeID primary key, autonumber
-txtExperienceType

Is it ok to keep you posted on how I am doing??

Absolutely!

[jzwp11]

Per your PM, I am attaching the user login demo database. I've removed the user combo box and replaced it with a text box so that the user is forced to put in their user name.

[REAPER_110]

Hi Greg,

Again, thank you for helping me out

Kind Regards,
Andrew.

[jzwp11]

You're welcome