R
Red
I am designing a database which keeps track of all of the jobs we have done
for our clients, using Access 2003.
There are 5 tables -
1. Clients (Client ID, Client Name)
2. Industry (Industry ID, Industry)
3. Jobs (Job ID, Client, Industry, Project Type 1, Project Type 2, Project
Type 3, Job Description, Year, Employee 1, Employee 2, Employee 3, Employee
4, Work example) - some of these fields are set as Lookup fields so the
information can be retrieved from other tables
4. Employees (Employee ID, Employee Responsible)
5. Project Type (Project Type ID, Project Type)
I would like users of the database to be able to search it by client,
industry or project type. I created a Client parameter query where one can
enter the name of a client, and all jobs for that client will appear. This
works OK. I intend to create similar queries to search by industry or project
type.
I then made a data access page based on the Client query. When the page
opens, the Project Type and Employee fields contain numbers, instead of the
actual project type and employee names. The other fields on the page (client
name, industry, and work example) all come up with the correct info. Why are
these 2 fields doing this??
for our clients, using Access 2003.
There are 5 tables -
1. Clients (Client ID, Client Name)
2. Industry (Industry ID, Industry)
3. Jobs (Job ID, Client, Industry, Project Type 1, Project Type 2, Project
Type 3, Job Description, Year, Employee 1, Employee 2, Employee 3, Employee
4, Work example) - some of these fields are set as Lookup fields so the
information can be retrieved from other tables
4. Employees (Employee ID, Employee Responsible)
5. Project Type (Project Type ID, Project Type)
I would like users of the database to be able to search it by client,
industry or project type. I created a Client parameter query where one can
enter the name of a client, and all jobs for that client will appear. This
works OK. I intend to create similar queries to search by industry or project
type.
I then made a data access page based on the Client query. When the page
opens, the Project Type and Employee fields contain numbers, instead of the
actual project type and employee names. The other fields on the page (client
name, industry, and work example) all come up with the correct info. Why are
these 2 fields doing this??