Create New Record in other File

[redballoon]

When I create a new user with a button in one Filemaker file I want to create a new record in an associated file so that the record can hold details of that user, ie counts for printing e.mail & the ability to brows users etc....

However I cannot see how to create that record in the associated file when the Create New user button is in another file, scripting does not seem to be able to do this but surely it is possible, it seems only logical that you Can do this ?

[redballoon]

OK I have created a relationship and enabled create record with this relationship but no record is created....

[LaRetta]

You must set a field in the other relationship. If you set a field other than the unique ID which binds them then the ID will fill itself in automatically. It is one of the first things I learned in FM and it tickled me so much I smiled for a week. :wink2:

[redballoon]

Thanks Charlotte,

I'm not sure what I have to do, I have created the relationship between two fields, one which is a user name and one the users password but the record does not get created..

The user is created in table 1 but the record for that suer in record 2 is not created, I'm certain you are right and this is really easy.... but not for me it seems....

[The Big Bear]

Red

What LaRetta is trying to tell you is that you must have more than the relationship field completed before a record is created.

[redballoon]

Thanks Both of you I got this working...

Quite nicely.

I have two Global fields in Table one.

Custom dialogue 1 asks for a new user name and password.

These are put in the two global fields

they have a relationship with two ordinary fields in table 2

The a script step takes the values from the ordinary fields in table two and uses them to createa new user and a custom dialogue comes up to tell you a user has been created.

The two global fields in table one are then voided for the next new user.

In all this a new record is created in table 2 with the new users name and password...

Great just what I wanted.

Now I can have complete user management.