Validation againts other tables

[sigtb02]

What is the best way to validate field values in one table againts field value in another table using P4 DB. I tried with FC file queries but i does not seem to flag me if i enter an invalid value. ref. ST1 (16-29).

[tommy]

I don't know whats the best way, that depends on the situation but there are several ways.



You can either specify it in the data policy, then it will apply allways.



On format ctrl you can do it on queries, just make sure you select true in the REQ condition.

[sigtb02]

I tried using the Req'd box and i checked that all condition came to true in the debugger pannel. But no result it saves the records without giving me the error message. What to do ??

[tommy]

Ok, I have not tested this on SC4 yet. I will test it now. In SC4 there are a few OOB examples on the cc.incquick.g format.

[tommy]

I just tested this on an OOB SC4.



Do this:



In cc.incquick.g goto formatcontrol, queries



Find the query that queries affected.item (you may want to change view to expanded) in the REQ field change false to true. Save.



Then try to open a call and specify an invalid asset, then you should get the message: Could not find item in asset file



Make sure that you don't have more than one message, you can see that if an * preceeds the message, then you can view all messages by clicking on the bold M in toolbar.