I have an INVOICES table with a portal show related records from a
LINES table. In the portal is a drop down list based on a field value
from a PRODUCTS table. I am finding the drop down list approach long
winded (too many skus) and would rather reference the Product
information by manually entering information, the information being
the product sku - my sku nomenclature is systematic.

The problem now is that if I drop the drop down list approach all
previous invoices will loose their reference, and all the related
field info will disappear. Does anyone have a good approach for
switching this referencing system?

Thanks

Greetings,

When I use Find to omit duplicates (records with the same value in the
same field), it omits *far* more than the duplicates. I have about
100,000 records and am left with about 100 when I should be left with
thousands.

I can't figure out what is going on. I click the find button, check
omit, and put an ! in the field I want to check for duplicates in.

Help