How can we help you today? How can we help you today?

foreign key generator - restrict data

The foreign key generator does not allow us to filter data selected from the related table.

I may have a field related to a table containing a list of states. When I generate data in the main table I want to be able to restrict which states are selected (i.e. Michigan & Wisconsin).

Currently I have to remove the relationship before I can select the SQL statement generator or RegExp generator.
rjschave
0

Comments

3 comments

Sort by
  • benhall
    Hello,

    Thanks for the suggestion, it is much appreciated. A number of other users have also requested this feature and we are looking at the best way of solving this for future versions.

    Once again thank you, if there are any other features would you like to see then please let us know.

    Thank you

    Ben
    benhall
    0
  • Aline
    Hello

    I'm also missing this feature.
    I think, for the moment I will delete this records with a script after data generation.

    Kind regards
    Aline
    Aline
    0
  • benhall
    Hi Aline,

    In the mean time, that is a great solution to getting around this the problem.

    Just so everyone is aware, the post generation script feature can be found on the project configuration dialog on the scripts tab.

    Thanks

    Ben
    benhall
    0

Add comment

Please sign in to leave a comment.