Associated fields

I want to create 3 fields that are tied to each other.
Field 1 is a city
Filed 2 is the year you entered the city
Field 3 is the year you left the city

How can this be done such that I can then search and say give me all users who visited London between 1990 and 1999 for example?

I want to create 3 fields that are tied to each other.
Field 1 is a city
Filed 2 is the year you entered the city
Field 3 is the year you left the city

You can use CB Conditional for that. So basically Field 3 shows if Field 2 has a value and Field 2 shows if Field 1 has a value. See the below for CB Conditional tutorials.

www.youtube.com/playlist?list=PLp0puRITgC7PxD6MvmDwNNIi2HNcYxs7u

How can this be done such that I can then search and say give me all users who visited London between 1990 and 1999 for example?

Search shouldn't require any special configuration beyond ensuring those fields are set searchable and on your userlist. Then when searching your userlist specify that criteria. See the below regarding userlist configuration.

I'm going to give this a try.

Thanks

Since this morning I have not been able to post a new topic. I get either

The website declined to show this webpage HTTP 403 OR

403 Forbidden
You don't have permission to access /forum on this server.

Is there something happening to your servers or site?

I want to create a drop down field using values from a column in an existing cb table.
Specifically I want users to be able select the name of other site users from the drop down.

Is there something happening to your servers or site?

More than likely what you're trying to post is triggering mod_security. Avoid including large chunks of code in posts.

I want to create a drop down field using values from a column in an existing cb table.
Specifically I want users to be able select the name of other site users from the drop down.

You need CB Query Field for that. The Query Select fieldtype builds its dropdown options from the database query you supply. So you could have it query for the name of other users. Example as follows.


I don't really recommend this if your site has a lot of users as you could end up with a dropdown with thousands of options.