Best way for single record table to be accessed by other forms/tab

[Guest]

I have a large database that incorporates about 25 forms so far. 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 was assign 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 a form, 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.

 

[Marshall Barton]

I have a large database that incorporates about 25 forms so far. 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 was assign 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 a form, 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.

How about using a subform bound to the one row table? Seems
easier than adding all those controls to every form and
joining the record in every query.

 

[Guest]

Thanks for the suggestion Marshall. It would work if the text boxes were all
in one location on each form. On one form the Project Expense Code is in a
heading on the left, the Contractor's name is in the middle below and the
start date and working days are down in the bottom section. I can't modify
the form because it duplicates one that is in use.
I'll live with the 1's I guess. It's a simple way to accomplish what I'm
doing.
Thanks again,
Rich J

 

[Marshall Barton]

Gee, I hate to give up so easily.

What about doing a cross product join the the form's record
source query. Maybe something like
SELECT T.*, R.*
FROM sometable As T, onerowtable As R

That should join the one row table's record to every record
in the other table without the need for an ON clause or the
need for the 1 fields in each table.