how to check if record already used

tinna

hi, urgent help, please

how can i check if record from one table has already been used, i.e. im filtering table x by vendor no, then i use this vendor no in my table. how can i check if its already there

tinna

I fixed it using temp table storing the values already taken, thanks

RockWithNAV

Filter with this Vendor on your table and see if it exists

navisionerin

yes but how if im getting this dynamicaly

RockWithNAV

What does that mean and how it makes a differnece?

tinna

I fixed it using temp table storing the values already taken, thanks

bbrown

Add an "exist" flowfield in your Vendor table that looks for records in the other table with matching "Vendor No.". Use this field to filter\select your vendors based on business rules.

This removes the need to rebuild\update a temp table with every change to the other table.