Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #436

Import File.....

Show all headers | View raw

Hi

I have imported several Excel files (one per manufacturer) into one
product database.  Example fields are: manufacturer, Product Code,
Description and Price.  Several important sales records in a sales
table now refer to this information e.g. product code is put in to one
field on the sales record and description and price are looked up and
inserted automatically on each line of a sales record.  As these are
all individual fields the look up is done by 'n' table ocurrences for
'n' number of invoice lines.

The predicament I now have is that the prices from one of the
manufacturers has now changed, but not by any set rule.

Without deleting the whole product table and re-importing everything
(because this would affect the sales records already created) how can
I import the new price column and ensure that each price will be
matched to the correct record?!  The thing that makes me nervous about
this is that the newly imported prices could be mis-matched between
records.

This is obviously a very important maintenance question from the point
of view importing pricelists to a Filemaker database; prices change
frequently and it would be good to know the best way of handling these
price changes this from other developers' point of view.

Many Thanks in Advance
JayBee

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar

Thread

Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-19 15:12 -0700
  Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 13:21 +1300
  Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 11:46 +1030
    Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-20 16:10 +1300
      Re: Import File..... cortical <cb@corticaldata.com.au> - 2011-10-20 22:17 +1030
        Re: Import File..... yourname@yourisp.com (Your Name) - 2011-10-21 09:14 +1300
          Re: Import File..... JayBee <Jennifer_Beecroft@hotmail.com> - 2011-10-24 15:07 -0700
  Re: Import File..... Martin Τrautmann <t-usenet@gmx.net> - 2011-10-20 04:41 +0000

csiph-web