F
freelancer
I want to add a default value to a field in a table based on a form I am
using. I am building a library database and would like to add each entry
via a form created for a specific type of record e.g If I want to create a
book entry I would select from my primary menu ‘create new book entry’ this
would open a form which has fields that relate specifically to a book [e.g.
ISBN etc]. I intend to create a form for each type of entry or record e.g.
book, journal, article, folder, other etc.
Within the main dbase table I have a ‘Cover Type’ field which indicates what
type of entry has been made as listed above. I want to be able to have the
form inset a de-facto type of entry to this field based on the specific new
entry I have created. Simply, if open the ‘create new book entry’ the value
in the ‘cover-type’ field will be book; similarly for the other types of
entry.
How can I have a default value based on a form rather than having one
default in a field in the main table?
I hope this makes sense and thanks, as ever, for the feedback.
using. I am building a library database and would like to add each entry
via a form created for a specific type of record e.g If I want to create a
book entry I would select from my primary menu ‘create new book entry’ this
would open a form which has fields that relate specifically to a book [e.g.
ISBN etc]. I intend to create a form for each type of entry or record e.g.
book, journal, article, folder, other etc.
Within the main dbase table I have a ‘Cover Type’ field which indicates what
type of entry has been made as listed above. I want to be able to have the
form inset a de-facto type of entry to this field based on the specific new
entry I have created. Simply, if open the ‘create new book entry’ the value
in the ‘cover-type’ field will be book; similarly for the other types of
entry.
How can I have a default value based on a form rather than having one
default in a field in the main table?
I hope this makes sense and thanks, as ever, for the feedback.