Way to Go to Specific Item when Field is filled?
Ok guys, heres one :)
So i Have the field Product # and Ref #. Both of which live in 2 Different Tables in the same DB.
In my line items, i have an Arrow to the Left of Product and Ref #. There will be line items that have a Ref or a Product #, NEVER both.
Clicking on this arrow, currently right now i have it just going to the Layout mode in that DB. thats all. but i'd like to refine it and make it so when clicking on the arrow, it goes to THAT specific Product using the Product item # OR going to the "Special Product" if the Product Item # field is blank and it finds somethings in the Ref # field it goes to the Special Product Layout and finds that specific Record. kinda stomped. thanks!