I have a relational database set up where i enter a serial # in the main database and it looks for a matching record in the related db. What I would like to do is... If there is no record in the related db I would like to have it create a record with the data from the related field. Does this question make sense? If so can someone point me in the right direction?

Thanks in advance

John

quote:

---

Originally posted by jfountain:

I have a relational database set up where i enter a serial # in the main database and it looks for a matching record in the related db. What I would like to do is... If there is no record in the related db I would like to have it create a record with the data from the related field. Does this question make sense? If so can someone point me in the right direction?

---

I assume that you are using a script? One way to do this would be to perform a find, or use the IsValid() function to verify that you do or do not have a a record.

Then if you do not have a record, you can simply call another script which goes through your process for creating a record.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=

Hi Cap'n- Thanks for your reply... Would you be able to elaborate more, specifically on the syntax of the script? I have been using FileMaker for exactly 3 days now and I think i need a bit of a guiding hand. (If not a kick in the a**)

-John

[This message has been edited by jfountain (edited February 13, 2001).]