Skip to Content
0
Former Member
Apr 25, 2007 at 03:11 PM

How can I check values?

25 Views

Hi,

I have a table called person:

ID, NAME, ADDRESS, YEAR, EMAIL, CITY,

and a list of cities(another table called city with only one field called name).

1) I want to import those records whose value(field city) is contained in table city.

2) I want to change the value of those records whose value(field city) is not contained in table city and the also import them.

Maybe there is a way to import them all and then correct the values in data manager???

I think I have to create a main table and import values from table person and then create a lookup table and import city names. But I am a little bit confused with this.

Can anybody help me with this?

All the replies will be rewarded.

Thanks and regards

Ivo