Fetch first 100 rows of the worksheet which has AGE column filled.
Maps age,status and color values with database record and returns PRICE in DOG table
If 1 row is mapped with table, then ALLOWED column field of that record in worksheet will be filled with price value
If more then 1 row mapped then ALLOWED column field of that records in worksheet will be filled with MULTIPLE string
If no records found then map with CAT table same as above
If no records maped with CAT table, then ALLOWED column will be blank.
Could not get 4th point perfectly. "age, status, and color is entered in real-time in a row" means?
Anything is possible when i am the coder.
Thanks