[CatDev]

Hi,
I created three customized extra field for the canditdates. These Information can be seen in opencats, but when I look into mySQL workbench I cant see a relationship between these extra fields and the candidates. How are they connected or how (with what keys) can I connect them?
Thanks!

[RussH]

the extra fields table (e.g. for Candidates) will have a 'Data_Item_ID' field. This is your candidate ID. you can join the two tables based on a match of this field.

[CatDev]

Thanks a lot! That makes so much sense of Course.
Unfortunately the Format isnt the same as for example:
Date Available:
Current Employer:
Key Skills:
Can Relocate:
No
Current Pay:
Desired Pay:

I would like to delete These Features and replace them with the ones in the extra field table.
Can you please give me a hint how to proceed on that?

[RussH]

Personally - I wouldn't delete them, I'd just hide them in the candidate view so the user doesn't see them.

[CatDev]

Thanks!

But can I also hide them when I add a new candidate ?

[RussH]

sure - just comment out the relevant fields. Make sure they're not mandatory though or you'll get into problems

[CatDev]

Okay, I will try it and hope that there wont be any bigger Troubles:)