How do I change the bound column without ruining the relationship between two combo boxes

[qabaselayan]

I have an issue where I'm trying to limit the data in one combo box based on another but when I change the bound column so that the text would be displayed in the bound table the relationship doesn't work and the second combo box displays nothing, please help.

 

[theDBguy]

I'd say don't change the bound column at all and don't look at the data directly in the table. Instead, create a query and use the query in forms or reports to view the data.

 

[qabaselayan]

I'd say don't change the bound column at all and don't look at the data directly in the table. Instead, create a query and use the query in forms or reports to view the data.

The thing is I can't create a report from a form so I bound the form to a table and the table to a report

 

[theDBguy]

The thing is I can't create a report from a form so I bound the form to a table and the table to a report

Like I said though, try binding your form and report to a query that combines all the data you want to display.

 

[qabaselayan]

The idea of my form is that it takes info from different tables and displays them in combo boxes and in the end I want a report that shows the chosen data

Forms and reports should be bound to queries rather than tables. This allows you to include joins to lookup tables so that you don't need to use combos at all on reports. It also allows you to add selection criteria to better control what you see.

So, in your report for example, you want to show the departmentName rather than the DepartmentID which is in the main table. Create a query that joins the main table to tblDept on DepartmentID and select DepartmentName from tblDept. That allows you to show the text value for Dept on the report without having to use a combo box at all. You still need the combo on the form because you want to be able to use it to control the possible values for Department.

 

[qabaselayan]

Like I said though, try binding your form and report to a query that combines all the data you want to display.

The data I want to display is coming from the combo boxes so I'll have the same issue if I use a query?

 

[qabaselayan]

Like I said though, try binding your form and report to a query that combines all the data you want to display.

I sent you an email with the file because I can't share it here, thank you

 

[bob fitz]

I sent you an email with the file because I can't share it here, thank you

You could share it here for the benefit of all members by simply removing all real records and replacing them with just a few fictitious records to illustrate the problem

 

[qabaselayan]

You could share it here for the benefit of all members by simply removing all real records and replacing them with just a few fictitious records to illustrate the problem

it says the file is too large

 

[bob fitz]

it says the file is too large

Compact and repair. Then zip it. Attach the zipped file.

 

[qabaselayan]

This is the database, I removed some tables so it would fit

 

[qabaselayan]

Compact and repair. Then zip it. Attach the zipped file.

I did that thank you

 

[bob fitz]

I did that thank you

I have looked briefly at your db. IMHO it would be better to deal with the problems in your table design first.
e.g. in table "Titles" you have an auto-number field but you have a text field set as the Primary Key
In table "Objectives" you have field "Outcome ID" as a text field
The use of spaces in object names (fields, tables, controls etc) should be avoided (use OutcomeID rather than OutcomeID
Although I have no idea what your db is actually about, the use of numbers in field names (e.g. Outcome 1, Outcome 2 etc) suggests to me that the db is not properly normalized.
There may be other concerns, these were just the things I spotted having a quick look around

 

[qabaselayan]

I have looked briefly at your db. IMHO it would be better to deal with the problems in your table design first.
e.g. in table "Titles" you have an auto-number field but you have a text field set as the Primary Key
In table "Objectives" you have field "Outcome ID" as a text field
The use of spaces in object names (fields, tables, controls etc) should be avoided (use OutcomeID rather than OutcomeID
Although I have no idea what your db is actually about, the use of numbers in field names (e.g. Outcome 1, Outcome 2 etc) suggests to me that the db is not properly normalized.
There may be other concerns, these were just the things I spotted having a quick look around

the database is used to create a lesson plan, and the user needs to choose outcomes based on the title, the text title is the pk because when I use the id number the cascading combo boxes don't work

 

[bob fitz]

the database is used to create a lesson plan, and the user needs to choose outcomes based on the title, the text title is the pk because when I use the id number the cascading combo boxes don't work

In the attached db I have made the Auto-number fields the PK's and adjusted the combo box properties accordingly.
However, the other issues I mentioned still need to be addressed
EDIT:
Sorry, just noticed that I missed the table "Titles" which still needs the auto-number field to be make the PK