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