Updating a related lookup table

Iron Speed Technical Forums

Iron Speed > Categories > Code Customizations V9.X > Updating a related lookup table

Note: Your browser does not have JavaScript enabled. Many features may not work properly without it. Please enable JavaScript in your browser settings.

Author

Comment

JBEMETO

Registered:1278716579
Posts: 161

Posted 1349878929	Reply with quote #1

Hello, One of my look up table comes very lengthy if it is not excluded after first time use from the records on adding a new record and updating it. I want to initialize a field of this lookup table by passing a value to the field when updating or adding a record to the transaction page. How can i pass this value to the lookup table . At what point can I do this?? I need the assistance. Thank you in advance __________________ JBEMETO

JimiJ

MVP Developer
Registered:1112254853
Posts: 1,958

Posted 1351211953	Reply with quote #2

I'm not sure if anyone understood this question. I can only assume that if the DDL where AddRecordLink is referred is not empty, it selected value shall be as a filter to the lookup. Cheers, Jimi J __________________ Jaime Jegonia Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:1278716579
Posts: 161

Posted 1351660943	Reply with quote #3

Hello Jimi, I have an add page. One of the fields is a lookup table My lookup table comes from a transaction table. I simply want to drop the record on that transaction table each time that record is used. Otherwise the records will grow too lengthy and clumsy. See attached. How do I filter these records to only unused record on the transaction table, which is a lookup up table on the add page? Attached Images __________________ JBEMETO

JimiJ

MVP Developer
Registered:1112254853
Posts: 1,958

Posted 1351776694	Reply with quote #4

You need to Customize the DDL population by filtering it with something like "TransID NOT IN (SELECT TransID FROM ParentTable). Cheers, Jimi J __________________ Jaime Jegonia Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:1278716579
Posts: 161

Posted 1351784526	Reply with quote #5

Thanks Jimi, I have a problem flaging the lookup table as i save/update the parent table (page). Can I get a headway on how to flag a field on that lookup table as I save the page or update it? Thereafter I believe I can filter the lookup table. Thanks again __________________ JBEMETO

JimiJ

MVP Developer
Registered:1112254853
Posts: 1,958

Posted 1351832051	Reply with quote #6

I don't think you should need a flag, but it should be dynamic. You may add where clause to the DDL existing source, or you may create a view to pre filter the new source then use it as DDL source without adding where clause. Cheers, Jimi J __________________ Jaime Jegonia Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:1278716579
Posts: 161

Posted 1371036578	Reply with quote #7

Hello Jimi, Thank you for your suggestion. I have just successfully implemented it accordingly. It is really dynamic. Thanks a great deal!!! __________________ JBEMETO

JimiJ

MVP Developer
Registered:1112254853
Posts: 1,958

Posted 1371042920	Reply with quote #8

I'm glad you made it work to your desire. __________________ Jaime Jegonia Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:1278716579
Posts: 161

Posted 1483602916	Reply with quote #9

Hello , I have a master record with a child records. The child record has a look up table from a parent. This parent record should not be available when taken by another transaction. The position of child record is to reflect on the master too. My approach has been to flag off the availabilty until it is released on saving the transaction using a stored procedure. But this is not dynamic as the unavailable records still show until another transaction is completed. What is the best approach in this circumstance? See attached. Any help is appreciated. Thank you Attached Images __________________ JBEMETO

JimiJ

MVP Developer
Registered:1112254853
Posts: 1,958

Posted 1483878371 · Edited	Reply with quote #10

Hi Benson, To make it dynamic in a situation like that, I always use GetRecord() in the Business Layer's Inserting or Updating Record methods. In this way, I can ascertain the data availability just before saving. Cheers, Jimi J __________________ Jaime Jegonia Iron Speed MVP Developer ". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Previous Topic | Next Topic

Easily create a Forum Website with Website Toolbox.

Modal title

Insert Code

Please paste your code into the box below: