Ok here the situation, i got 6 different files and i want to use one of those files as a "search file" in which all the fields in the "search files" would be able to search in the other one. In all my files i got 17 fields that are the same. Now how would I proceed to create this search file so that i would be able to go in my "search file" and type a name or a last name or name of a street or even the name of the city. and it would search the other files.
I want to create a field that would always add the number preceding it, the field would be cumulative. Is this possible and if so , how do I proceed. This field would be part of a timesheet and it would add time spent on projects by different employees
thanks
Gary