I have 2 databases (people type a and people type :,

but i need them to have a unique alias.

the databases are seperate, because they have to many different fields and calculations.

can i look up if the alias is unique in the other database?

What do you mean by "alias". That isn't a FileMaker term. Do you mean that there is a certain field in both of the databases and that you need to make sure that between the two of them that field is unique?

Chuck

yes, that's exactly what i mean

Hi Concrete,

My previous database had the same structure, with different files for Customer and Supplier. The problem rised when some suppliers became customers and vice-versa.

I now changed to a unique file, but in your case, I would hold the Unique_ID into another file, the Account file.

My previous database had the same structure, with different files for Customer and Supplier. The problem rised when some suppliers became customers and vice-versa.

I now changed to a unique file, but in your case, I would hold the Unique_ID into another file, the Account file.

Ugo,

could you please tell more about that your current structure (or point to an appropriate post, if any). Very interesting. I have the same problem/structure and I'd like to know your opinion on these. Personally, I feel that 4 basic + a couple of supporting files would be enough for a database of any complexity; the rest can be programmed