Posted on 2006-05-17
I have this fantastic database which has a few forms. Many of these field on those forms are performing view keyword lookup from a lookup view based on a keyword documents.
Now, I want to make this lookup a bit more sophisticated. For example, at the moment, one of the key lookups is product code, this field does a lookup and all the product codes are populated in the product code field. But I want to be a bit more specific, I want to be able to store and lookup product codes based on a customer, for example, if customer A is stored with products, (A, B, C) and I want to go back into that customer document and change the product field, I want to be able to view in the drop down list(A,B,C) only and not the rest of the product codes which may belong to other customer.
The second trick to this, is to populate the entire product list if the customer is a new customer, which does not exist entirely in the database. However, if it is a new doc, but the customer exist in db, I want to be able to pull out only the customer specific list.
Now, is this possible?
Thank you all in advance