Find, Show Omitted Only, Then Find Again

[Juerg]

Hi all,

 

I'm struggling with the following scenario and would be grateful of any help.

 

I need to synchronize two customer tables. The 'main' table is from an SQL database connected via ODBC and will be the 'master'. I need to add any new records from the SQL table into my local FM database (deleted ones don't matter). To find the new records manually in FM I can place an ID field from the FM customer table onto the layout showing the SQL customer data and do a Find for *. This shows me any matching records between the two tables. If I then Show Omitted Only I then see the New records. My problem is that I then need to remove any records which have a value of 0 in a particular field.

 

Essentially I need to Find "*", Show Omitted Only, then Find "Delivery = 0" within the current found set.

 

With my current data I know I show end up with 1 record but I just can't do it!

 

If this is not clear, please let me know and I will try again to explain.

 

Thank you in advance for your help.

 

Juergen

[Juerg]

Problem solved. Tried to delete my original post but can't.

 

Just a simple script step -

 

Perform Find [Restore] with Actions:

Omit Records,ID:[*]

Omit Records,Delivery:[1]