SQL - Check Existing Data on Creation or Re-enabling

SQL - Check Existing Data on Creation or Re-enabling

  
Hi everyone,

I need to do in some OutSystems tables with foreign keys linked to the Lookups that import does not check for the lookup.
Is there any way to make this option "check exist" in the creation of tables OutSystems outem to do it manually in SQL?

This is for the import faster since they are more than 300000 records.

Sample:

Table1
Id
Name (VarChar)
Sex Char(1)  (foreign key with table2)
  1. Row1 1 - Zé manuel - M
  2. Row2 2 - Jusefina   - F

Table2 (Lookup)
Id Char(1)
Description

  1. Row1 M - Male

output
  • Zé Manuel - Masculino
  • Jusefina -

Best regards,
Daniel Maia
HI Daniel

Sorry ... didn't understand the problem from your description.

Can you rephrase it?

Thanks

Cheers

Miguel João