Changing an initial value on data entry

I have set an initial value that I would like to change to a yes / no field on which I can click when entering data. Ex .:
Title: Person (Initial Value)
Yes / No: No (initial Value)

If I click on “No” I would like “Company” to be written automatically on Title

Solved Solved
0 2 150
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

View solution in original post

2 REPLIES 2

I don’t get it.
Could you post here your table schema? I mean, the columns from your table and it’s type

An Initial Value is for any column, and it’s a way to have a default every time a row is created. You can change a column type to Y/N but it has nothing to do to Initial Value, just make sure the Initial Value expression returns the same type of data that is expected taking into account the column Type.

Steve
Platinum 4
Platinum 4
Top Labels in this Space