as you will see in my "users" database, i have a lookup field. whenever anyone makes an order their details go into my users database. is there a script that will be something like "if email address exists dont import this record"?? if so could you edit my database files so that it uses this script? thanks a lot

Version: v6.x

Platform: Mac OS X Jaguar

Hi,

This attachment wouldn't open for me...

Well, if I understood, you'd just change the key from which you're making the match.

So instead use a calculated key as your key, of type

c_ConditionalTrigger = Case(not IsEmpty(EmailAdress,"",YourIDField)

Version: v6.x

Platform: Mac OS 9

You would probably be better off having people register their info in a separate step to create an account. Then they would just reference that account when placing orders. If they try to register, or create an account that has the same email address, you could use field validation on the email field to force a unique value.

i really dont understand any of what either of you two sed. ive just started using filemaker so am very new to it all!