Table Values from combo Box Input

[Kennertoy]

This will probably sound very elementry to the experts - I have been away from Access for a while and it may be a very simple fix.
I have a small DB for a birthday/Anniversarys. I have tables for the record, including, name, address, birth date (month & day), anniversary date if required. Also a year table for birth day, and a year table for the anniversarys. The form I created has combo boxes for the DAY, MONTH for the birthday. And combo boxes for each of the birthday YEAR and the anniversary YEAR. When you input data in the combo boxes it populates the field correctly on the form. When I look at the record table, in each of the year fields showes the key number, and not the year as is shown in the form combo box.


When I run a query it also showes the key number from the table and not the value of the year. What did do wrong? I have set the relationships from the record table to each of the other tables (3) and type 2.

I'm using Access 2010 if it makes a difference.

[June7]

You have the key field in the combobox RowSource. You have the key field column set as the BoundColumn. The BoundColumn value is saved to table.

If you want to show the alias data then must include the source table in the query by joining on the key fields.

[alansidman]

You have done nothing wrong. What you have is correct. The table holds the bound column data and not the description. This is proper. In your query, you will need to bring the tables that contain the lookup values for your combo boxes into the query. You will then need to bring those fields into the grid (you can uncheck them so they are not displayed), but you will need to set the criteria in them and not the descriptive fields. I hope this is clear to you.

This link should help you to understand also.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[Kennertoy]

Thanks Alansidman for your reply. I guess I am still in the glue. I put the tables in the query, as yoiu recommended, (they show the relationships) Then, I include the table entries (years) in to the fields of the query and when I run the query I get an error message 'the SQL statement coudl not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first create another query ...'. I don't know what Criteria I should use to get at the right data.
if I delete the table relationships it will run but I get 618520 entries in the query when I only have 70 records entered so far.
Sorry for being so out of it. Thanks for you help.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[Kennertoy]

Thanks to all - I have solved my problem. I re-worked the DB and now works! LOL

[Kennertoy]

This thread should be closed but I cannot find the option.

[June7]

Under Thread Tools dropdown above the first post.

If there are details to your resolution that would be of interest to other readers, a posting would be nice.

[Kennertoy]

I changed the tables (two for years) into one and changed the design of the db to allow one pointer to the year table and made it text. I already had
a solution for the month pointer in the query. Hope this helps newbies. Thanks again to all the advice. Thanks Super for the advice too.