I'm trying o figure out a calulation. I know how id do it in PHP or C++ but cant find how to translate that to the Calcualtion funcion in the database define calulations.

A little help?

psudo php code

If ((isset(CompanyID)){

if (Records::Company == '' AND Records::CompanyID == CompanyID){

UniqueName = Records::First Name;

UniqueName .= " ";

UniqueName .= Records::Last Name;

}else{

UniqueName = Records::Company;

}}

also simpley setting UniqueName = Records::UniqueName would work what im really hung up on is how i woudl check for CompanyID, match it against Records::CompanyID and then find the relevent records to generate either the above Unique name or the the more complext claulation inthe previous post

this is about as far as i can figure

If (CompanyID = Records::CompanyID; cUniqueName = Records::cUniqueName; "No Match" )

imtrying for the simple one first

if CompanyId = the company id in Records cuniquename = records unique name

but the result its returning is a ?

I'm not sure what you're doing, but you don't really need a calculation to get the value of Records::cUniqueName. You can use the relational tools in Filemaker to get it more directly.

Assuming the current table is called CurTable, create a relationship between the ID fields (you do this on the Define Database/Relationships page)

CurTable::CompanyID <-> Records::CompanyID

Then, if you put Records::cUniqueName on your layout, it will have the cUniqueName for the record in Records that has the same CompanyID.

You might want to look into some relational design theory to get a better grip on this most powerful aspect of databases.

HTH,

David