unique field in two databases

[concrete]

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?

[Chuck]

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

[concrete]

yes, that's exactly what i mean

[Ugo DI LUCA]

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.

[mse]

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