Lookup problem No. 2

HCL Domino Domino Forum
1

Had a problem this morning that a kind soul solved in about .02 seconds. Guess I’ll go back to the well again.

Fair warning - I’m not a Notes programmer, just construct things using Designer.

I have a subform with two fields and an embedded view.

Field No. 1 Selects a State using Combobox Keyword dialog.

Field No. 2 Selects a city by looking up the City name in the StateCity view (this is a view of all Client entries, the first two columns being State and City) and eliminating duplicates.

The embedded view should be a list of Clients in that City and State.

How do I do this? Can I embed the StateCity view and limit it somehow, or do I have to have another view? How do I pass along the values of the two fields to the embedded view and limit it?

Help much appreciated!

Mark

2

Subject: Lookup problem No. 2

Mark,

You can have views only displays values for a specified category. You will need your view to be sorted/categorized by City/State and have that view embedded on your subform. In the ‘Show Single Category’ property for the view put in a formula which evaluates to the City + State as it would appear in your view.

I think you should then be able to change the properties on the City selection to ‘Refresh Fields on Keyword Change’.

I think this should work but at least it should point you in the right direction.

Regards,

Alex Elliott

AGE Computer Consultancy