Parameterized query

[LiveOak]

The straight forward (and clean) solution is to put all four price lists in the same file and use the index to select one. Another option is to use four layouts, one with a portal to each of the four files. Enter the price list selection into a field (could be a global) and test the field to select a layout to jump to. -bd

[This message has been edited by LiveOak (edited December 22, 2000).]

[rior]

Win98, FM5,

Hello:

I have a db that, when creating an invoices, requires looking up to one of 4 different pricelist files (tables).

Each file contains similar items but different prices (obviously). The descrptions vary as well.

I would like for the user to select a PriceList (ex: North America). This could be assigned somehow as a parameter so that the Portal would look up the correct file name based on said parameter.

How can I do this in FM5?

in sql it might look like: Select * from [NorthAmericaPriceListFile]

where the [...] is supplied the variable the user entered...

Thanks

Rior