John, it's usually a bit quiet on this list over the weekend and I'm not at all sure that I follow what you're trying to do.
However, here's a couple of suggestions that you can throw back if you want with some more detail if you can: Firstly, it sounds as if you can use the same "where and &val" clause to select the row that you want to edit as you do at the moment. If so, you can use this to display the row on your form based on the Rates table in a DBEdit based on the Schedules table. However, it sounds as if you don't have a simple link between your tables so this could be a problem. Alternatively, and especially if a link between the tables is your problem, you can use the "where and &val" clause in your EEP to pop-up a second form based on the Schedules table: edit using [new form] ... where and &val If the row doesn't already exist in the Schedules table then I would create it in your EEP first and pop-up a second form based on the new row to edit. Regards, Alastair. ----- Original Message ----- From: "John Docherty" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, September 18, 2004 8:47 PM Subject: [RBG7-L] - Matching Values I have an estimating package which has a RATES table and a SCHEDULE table. The RATES table includes an item description (column de) and, as the description for the same item can vary depending on the consultant preparing the schedule, another column which includes the basis of a select clause used to identify the item (column al). Each row in the RATES table has a unique number identified by column rseq. eg: de: 400 dia spigot with damper al: (de contains ‘400’ and de contains ‘spigot’) rseq: 100 While using a cursor to step through the RATES table, and an update clause, I can extract the appropriate rates and update the SCHEDULE table (update schedule set .... where and &val; val being the variable extracted from the al column using the fetch statement) I am trying to develop this package to allow manual entry of the data into the SCHEDULE table (so far this is imported from a spreadsheet supplied). As part of this I need to determine a way of doing this from an EEP in a form as soon as the description is entered into a form. This would require a command which selects a row in the RATES table where a select clause returns a match between the description in the SCHEDULE table (which would be a variable from the form) and the predefined select clause stored in the RATES table. Select rseq from RATES where &al is true If anyone has any suggestions as to how this can be achieved I would appreciate your assistance. (Maybe I have just missed the obvious here.) Thank you, John Docherty -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.271 / Virus Database: 264.9.3 - Release Date: 17/09/2004
