Re: how to lookup on composite key

In <30268@dog.ee.lbl.gov> biocca@bevsun.bev.lbl.gov (Alan K Biocca) writes: >I need to do a lookup in perform, but the table requires a two-column >composite key. No combination of syntax I've tried works. Is there >a way to do this? I don't think this can be achieved with the lookup attribute. Look at the way the stock "lookup" is achieved in sample.per in the demo database. Would this not suit your needs? graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.