Whenever I add a new record to a table with a form I created, it records the "ID autonumber" that it's associated with instead of the text. For instance, if I selected "Kevin" from a combobox list and had the form record it, it will show up as "1" in the table under the field name "Names". Any idea how I can fix this?
Forms and Records Issue
- Thread starter Treisio
- Start date
Are you using a combo box.
If so then the box is bound to the first field in the box.
This field is likely the ID number.
As a side note, this is what I would want. I would not want to store the text just the reference number.
Dale
If so then the box is bound to the first field in the box.
This field is likely the ID number.
As a side note, this is what I would want. I would not want to store the text just the reference number.
Dale
I tried switching the first field in the box and it did not work. The problem is that when I generate a report from the table, it shows all the ID numbers of the objects I chose from the form. This makes the information almost useless to the users that will be reading it.
- Local time
- Today, 08:07
- Joined
- Sep 12, 2006
- Messages
- 16,072
well, when you do a report, you have a query which joins the data table with the names table, and then base the report on the query.
the other benefit of this, is that you can use this query to select a particular range of data for the report.
this is the right way to go. if you decide Kevin needs to be called Kevin Jones - you only change it one place - in the names table - and all the links still work.
the other benefit of this, is that you can use this query to select a particular range of data for the report.
this is the right way to go. if you decide Kevin needs to be called Kevin Jones - you only change it one place - in the names table - and all the links still work.
Similar threads
