Table-based Combo Box problem running Reports?

[KFuessel]

I have created a Software License database to keep track of software licenses. It includes a table-based combo box named "Software". The table associated with "Software" is named "Software List", and it's two fields are named "SoftwareID" and "SoftwareList". The "SoftwareList" field stores the actual name of the software application and "SoftwareID" is an AutoNumber data type field.

The problem is that when I run a report that uses the "Software" combo box, it returns the value "SoftwareID" instead of "SoftwareList". In othe words, I get a number instead of the actual name of the application. This is also a problem when I use the "Software" combo box in calculations and functions.

Any advice or help to this problem will be greatly appreciated.

 

[PHV]

Have a look here:

http://www.mvps.org/access/lookupfields.htm

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886