On Tue, 16 Feb 2010 08:38:43 -0500, "WSR" wrote:

I have developed a investment input form with look-up lists to restrict the
types of data to be entered.

The look-up lists come from subtables in the database.

When new records are saved the data is stored in a master table which I then
use to run Reports, Pivot Charts, Queries etc.

However, I'm finding that the master data table is in the same look-up list
format as the subtables that are used to populate the form.

In other words, the master data table has drop down choices for each record.

I'm finding that when I try to run a report the investment information is
lost. Instead of investment name I get results that show 1, 2, 3 etc.

My current work around is I export the master table data to Excel and then
re-import it as a flat file.

This is cumbersome and I'm hoping you can help.

Is there a way for the master table to store just data as a flat file and
not take on the look-up list format of the subtables used in the input form?

Sorry this is so long. I hope this makes sense. Your help is greatly
appreciated.

Thanks. (B^)-]=[


You are another victim of Microsoft's misleading, nonstandard, limited "Lookup
Wizard".

Your main table APPEARS to contain the investment name. It doesn't! It
contains a number, a link to the lookup table. That simple fact is hidden from
view by the combo box.

The solution is to base your reports, pivots etc., not directly on the master
table, but on a Query joining the master table to the lookup tables. Select
the master table fields from the master table, the investment name field from
that lookup table, and so on.
--

John W. Vinson [MVP]