how to Perform lookup with foreign and primary keys

• komal145

  SSCrazy Eights

  Points: 9918

  More actions

  June 9, 2016 at 3:38 pm

  #319373

  I have two tables Table A ( primary key )

  table B ( foreignkey refrences Table A primary key)

  Need to load data from a view "vwtableB" to "Table B" also check for foreignkey references with TableA ?

  should not duplicate data into TableB so using lookup on vwtableB.

  How to chekc foreignkey references at same time?

• larskandersen

  Ten Centuries

  Points: 1232

  More actions

  June 10, 2016 at 6:54 am

  #1884371

  Lookup only allows for one condition. If you want to test for multiple conditions, use the conditional split instead.

  From a readability and maintenance perspective, I would use two consecutive lookups instead of a conditional split.