I have a table that has a field where I use the look-up from another table's field. When I put this into a form or report. It returns an integer in the field rather that the value (text) from the look-up drop down. How can fix this?
I have a table that has a field where I use the look-up from another table's field. When I put this into a form or report. It returns an integer in the field rather that the value (text) from the look-up drop down. How can fix this?
Make a select query that joins your main table and your lookup table and use this as the underlying data for your forms or reports. Then you can put the data from the main table and the corresponding text from the lookup table on the form/report easily.
As Jim says, if you want the value from the linked table then you will need to include it in your record source. This is done by creating a query with the two tables linked.
Comment