I have a database that has two views one with Range Names the second with the range name and colors.(Products) I need the the lookup to first lookup a range name from the Range Names view. If this field then validates the second field needs to use this field name called Style to lookup into another...