Ok, I have a really messed up database for a client, but the software program they use means I cannot change the relationships.

There are two tables both use a pk that has multiples of itself in both tables. There is no way I can get around this either. I thought of creating another table and putting unique values from one of the id fields in it so I could reference the second id, but I am not sure how to go about getting unique fields from the other table without using sql, but I guess filemaker doesn't let you just use sql in the database without setting up an odbc connection to a database first. So my question is, is there a way of getting unique entries from a field that contains multiples of the same id number, without using sql? somewhere in the scripting? Or could I run a script on a field to remove duplicate id numbers?

Create a value list with the field you are wanting the value from. This value list will only give you ONE of each value. Then, you can use the function:

ValueListItems ( fileName ; valueList )

If you want to use them in a script or set field step.

Thanks, that helps.