how to check if record already used

tinna · 2021-07-20

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 · 2021-07-21

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

RockWithNAV · 2021-07-20

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

navisionerin · 2021-07-20

yes but how if im getting this dynamicaly

RockWithNAV · 2021-07-21

What does that mean and how it makes a differnece?

tinna · 2021-07-21

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

bbrown · 2021-07-22

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.

how to check if record already used

Best Answer

Answers

Categories