G
Guest
Can you have the default value, be conditional to another field in the table?
Example I want the default value m-f to be different than the weekend. Is
there a way of acheiving this?
Another question is there a way of creating a key from other fields in the
table, for instance, name, date time are other fields, I want the primary key
to be all 3 together therefore they will not be duplicated? I tried doing
this with a form and a macro to update the form, but for some reason it
didn't update and then I couldn't go on because of the primary field being
empty.
Example I want the default value m-f to be different than the weekend. Is
there a way of acheiving this?
Another question is there a way of creating a key from other fields in the
table, for instance, name, date time are other fields, I want the primary key
to be all 3 together therefore they will not be duplicated? I tried doing
this with a form and a macro to update the form, but for some reason it
didn't update and then I couldn't go on because of the primary field being
empty.