G
Guest
I have a large database that incorporates various forms. At the beginning of
the project, initial information is entered in a single record table that
will never change throughout the course of the project. Such as: Project
Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
etc. 19 fields in all that won't change.
The other forms need access to this data. What I have done is assigned the
primary key the value ' 1 '. I have a field in every table that is 1 bit in
size and each form automatically puts a ' 1 ' in the corresponding table for
each record.
When a person opens the form they are using all the information is there and
it works great. Each form is based on a query that takes the information
from its table and the Project Info table and fills in the corresponding
text box.
I can't help but think that there may be a better way to have access to the
information than repeating this ' 1 ' hundreds of times even though it is a
tiny size field. Comboboxes would work but seem even more complicated for
this.
Thanks for any comments or advice.
the project, initial information is entered in a single record table that
will never change throughout the course of the project. Such as: Project
Start Date, Project Expense Code, Contractor, Number of Working Days allowed,
etc. 19 fields in all that won't change.
The other forms need access to this data. What I have done is assigned the
primary key the value ' 1 '. I have a field in every table that is 1 bit in
size and each form automatically puts a ' 1 ' in the corresponding table for
each record.
When a person opens the form they are using all the information is there and
it works great. Each form is based on a query that takes the information
from its table and the Project Info table and fills in the corresponding
text box.
I can't help but think that there may be a better way to have access to the
information than repeating this ' 1 ' hundreds of times even though it is a
tiny size field. Comboboxes would work but seem even more complicated for
this.
Thanks for any comments or advice.