|
I have a "rules" file whichcontains the following fields: MFD - master field name (a field name in file MMST) MFV - value for field name above EFL - environment file name (could be 1 of 7 for example INVMST) EFD - environment field name (field name from file named above i.e. DEPT) EFV - environment field value (value for field name above) the user selects a record in the MMST file (ie. SKU: 12345) and it shoudl then populate based on the rules each fo the fields/values in the appropriate environment file: Example: Rules file: MFD=CORG MFV=US EFL=INVMST EFD=BUYR EFV=123 So if the CORG field='US' in the SKU record selected from the MMST file I want the BUYR field in INVMST to be set to 123 What I have "tentatively" done (and I don't like it) is shown as a "small snippet" below, FYI In the MMST file I have 20+ fields and I have (as of right now) 7 environment files which have multiple (5-50 approx. fields) IF MFD='CORG' and CORG (a fld in MMST) = MFV and EFD='BUYR' eval BUYR=EFV endif My "befuddled" mind right now sees that I would ahve to this the above for EVERY field in in every file?? Gotta be an easier way???????????// --------------------------------- Yahoo! FareChase - Search multiple travel sites in one click.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.