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^)-]=[