Compare two tables to verify the information of the first table and change the status
Hello
I am new with creator and I have to decide if it works for my necessities.
I have two tables:
- Orders from Client
- Product list (a list of a product I sell)
Step 1
I receive from my clients orders with the following fields
Client name
Client Order number
Date
Product code (mine)
Photo
Step2
I need to compare the photo (and other info) on the order with the photo+ info inside my Product database.
So I need list (grid to see more than one order at the time) that on one side shows me the order photo/info and on the other side (with a lookup) shows me the photos+info on my database.
Step3
For each order I need to change order status from order to verified by me
Is this possible?
Thank you