Auto Fill Field
I would like to auto fill a specific field for every new reord of a table with the same value. I have a table that includes a field "project Number". When you add a new record the same Project Number needs to be included for every record. I have tables for seperate projects and need to compare information from 1 project table to the other project tables.
I cannot imagine a circumstance where it would be appropriate to have a seperate table for each project, but regardless, you can use the Default Value field property.