R
Rich J
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 to automatically fill in the
information. 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. The join is ProjID in both tables.
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.
I previously posted this in the General Questions section. I got one
response to take out the ' 1 ' and just pull down the fields needed into the
query. This gives the "..ambiguous outer join.." error message.
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 to automatically fill in the
information. 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. The join is ProjID in both tables.
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.
I previously posted this in the General Questions section. I got one
response to take out the ' 1 ' and just pull down the fields needed into the
query. This gives the "..ambiguous outer join.." error message.