self join relationship problem

[davidrichards]

I am creating a database which will accept new orders and look to older, shipped orders and last names to see if the new order is from a prior customer. This will allow me to assign the prior customer ID number rather than a new one.

The relationship is order_status="shipped" AND lastname = lastname.

Unfortunately, it doesn't work. Only the lastname match seems to work, not the order_status=shipped. Any thoughts?

I am using FMP 8.5 on a Mac.

InternetVenturesDownloadExp.fp7.zip

Edited April 19, 2007 by Guest

[Greg G]

You just have your fields reversed in the relationship.

Switch Status_is_Shipped and OrderStatus around.

Since the OrderStatus is the variable field it needs to be the one that the portal is dependent on. I would also suggest that you use a global calc field instead of an auto-entered value. Just make the value of the calc "Shipped".

Edited April 19, 2007 by Guest

[davidrichards]

Excellent!

Thank you!