Tables

[Excel GuRu]

I have a linked table with customer information from an Oracle database. I'd
like to store customer information for certain customers in a separate table.
I'd like to use the same customer number as in the linked table, but would
like some information from the linked table to appear in the new table.
First of all, I only want to store information on the customers that are in
the linked table. So as new records are added to the "customer info" table,
I want the customer number range to only be the customers that exist in the
linked table. Once a valid customer number is selected, I'd like the table
to be populated with the name and address, for instance.

I'm having trouble getting this setup. It doesn't seem like it should be so
difficult.

Once setup, I envision

 

[KARL DEWEY]

Not a good Idea to store the same information in more than one table as it
will get updated in one but not the other. Just join the tables in your
queries to have the information available for you when you need it and be
current.