Single record table - other tables using this information

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.
 
A

Adam P

If it is a single record in the table, try adding the table to your
existing query without a join and dragging down the field(s) you need.
 
G

Guest

I tried deleting the join between the key field in the Project Info table and
corresponding field in several tables and got that 'ambiguous outer join'
error message that wouldn't let the query run. If I reconnect the join the
query works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top