adding a record in a separate table

[crebma]

I am lost again. I need to be abe to click a button in one database that will add the relevant info to another database. I have both of the relevant tables int he relationship part of both databases, I just have no idea how to set up a relationship.

One is an events planning database and the other is a customer info database. So far I have tried saying last name in one is equal to last name in the other, but i have no idea what that means to the database, since it's not working out. The script in the events planning one says simply to call the add script in the other database. The add script in the other database says:

New Record/Request

Set Field [Contact Management::Last Name; Banquet Database:: lastname]

and so on with several different fields. When I click the button in the events planning db, it will ad a new record to the customer info db, but there's nothing in it. and and all help would be greatly appreciated!!

amber

[RalphL]

I hope that you are using key fields other than last name. I am assuming FMP 7. To start with add a global field gKey. In your script set gKey to the Key field, then go to a layout for the other table, then create a new record and set the Key field = gKey.

Take alook at the attached file

[crebma]

I did switch to using an auto-enter serial instead of the last name after a bit more poking around.

But the problem is that my mental framework of what I was trying to do was completely different than what needs to be done. Learning Filemaker after learning any manner of coding language becomes difficult because you keep trying to make everything much harder than it actually is.

Thank you so much for helping me out, I really appreciate it!