Iron Speed Technical Forums
Register Latest Topics
 
 
 


Reply
  Author   Comment  
JBEMETO

Registered:
Posts: 160
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

Avatar / Picture

MVP Developer
Registered:
Posts: 1,929
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
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:
Posts: 160
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
Click image for larger version - Name: limittranlkup.jpg, Views: 42, Size: 44.90 KB 

__________________
JBEMETO

JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,929
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
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:
Posts: 160
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

Avatar / Picture

MVP Developer
Registered:
Posts: 1,929
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
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:
Posts: 160
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

Avatar / Picture

MVP Developer
Registered:
Posts: 1,929
Reply with quote  #8 
I'm glad you made it work to your desire.


__________________

  Jaime Jegonia
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

JBEMETO

Registered:
Posts: 160
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
Click image for larger version - Name: masterChildParent.png, Views: 7, Size: 13.00 KB 

__________________
JBEMETO

JimiJ

Avatar / Picture

MVP Developer
Registered:
Posts: 1,929
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
[jts_logo]

Iron Speed MVP Developer
 

". . . and whoever sows generously will also reap generously" 2 Cor 9:6

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Download Iron Speed Designer

Terms of Service Privacy Statement