Creating a Data Generation Plan that Includes Correct Lookup Table Values
I'm just getting started with Visual Studio Database projects and loving the data generation plans I can create with it. However, in one of my projects I need to populate a lookup table with specific values. Since a foreign-key relationship exists between the lookup table and another table, I can't remove the lookup table from the data generation plan without removing the other table from the plan. But then I can't generate any data for the other table. 

How can I either a) specify the exact data I want the generator to use when adding data to the lookup table, or b) have the generator not add new values to the table but instead use values that already exist?

Thanks!
Creating a Data Generation Plan that Includes Correct Lookup Table Values
===

I'm just getting started with Visual Studio Database projects and loving the data generation plans I can create with it. However, in one of my projects I need to populate a lookup table with specific values. Since a foreign-key relationship exists between the lookup table and another table, I can't remove the lookup table from the data generation plan without removing the other table from the plan. But then I can't generate any data for the other table. 

How can I either a) specify the exact data I want the generator to use when adding data to the lookup table, or b) have the generator not add new values to the table but instead use values that already exist?

Thanks!