1 to many relationship add related records

[eddyb2]

Hi all,

Am a bit confused by this...

I have 4 tables, the first being the main table

The key field in all tables is "serialno"

I have the following relationships setup

MainTable serialno -> Table2 serialno

MainTable serialno -> Table3 serialno

MainTable serialno -> Table4 serialno

Against all these relationships I have ticked the option to allow creation of records in the child tables via the relationship

What I expected to happen was that I would create a record in MainTable with for example serial number 123456

then when I went into the subsequent tables 2,3 and 4 there would be a record in there with serial number 123456, but this isn't so

I create the record in the main table and this does nothing to the other tables.

I cannot use a script or portals to do this for other reasons.

Has anyone any ideas why this may not be working or am I reading into what this feature does incorrectly?

Many thanks

Edited October 3, 2006 by Guest

[Genx]

The second one -- your reading into what the feature does incorrectly.

The feature specifically has to do with creation through portals (or scripts, but we'll leave that one alone). What it does is creates a "ghost" record in a portal, that when entered into will automatically create the required record in the foreign table with all necessary criteria to meet the relationship.

I.e. if you relate by serialno and a datefield and add some data to the "ghost" row of the portal, it will add a new record to the foreign table with the same serialno and same datefield.

[eddyb2]

Hi

Thanks for your reply.

In the filemaker help I read the following...

You can add records to a related table when you enter data in a record in the current table.

Add a record in a related table

If the related field is in a portal, type data into the field in the last row of the portal. If the related field isn't in a portal, type data into the field, then press Enter.

This seems to suggest that a portal is not necessary?

Thanks

Edited October 3, 2006 by Guest

[comment]

A portal is not strictly necessary - if you place a related field on the parent layout, a related record will be created when you enter data into the child field. But this will only work once (a related field outside of portal always shows data from the FIRST related record).

[Genx]

What / he said :

Edited October 3, 2006 by Guest