I have a field in a table that I would like to have it's default be the same as another field in the table, unless I indicate otherwise. I.e., I have the following fields:
id (primary and auto-incremented)
parentid
I would like parentid to be the same as id, unless I say otherwise (i.e through changing values through a form, or something). Anyway to do this that is inherent to the table itself (I know I can do it through my form when creating records, but I'd rather it just be part of the table itself, if possible). Thanks!
