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 view called products and allow the user to select the color only from the range name selected in the previous lookup.
Please help I am stumped as I do not have any lotus script knowledge.