Creating a relationship with value lists?
I have a table called "job tickets" This is where all my company's jobs are held.
I want to make a relating table called "reserve stock" which will only show job tickets that are marked as reserve stock for customers. The tickets are marked "reserved" via a radio button field with a "1" value to use to check the box.
So my first question is can you create a relationship based on a value set?
Additionally I have my reserve stocks with levels in a "Customers" table.
I looking to somehow in my "reserve stock" layout show all job tickets that are marked as reserve stock. Then add up the specific products by customer/product id. Then compare them to the stock level in my "customer" table and conditional format them to red if we need to order in more stock.
This is way to over my head. I would really appreciate any help walking me through this!
Thanks so much!