how to auto-populate 2 key fields in related file

[milen]

Hi,

I want to create a master file with 2 key fields and related file with the same 2 key fields.

For one master record there will be more than one record in the related file.

When I add new records in the related file I want to populate the key fields in the related file with the values of the key fields of the master file.

I don

[cjaeger]

please, please be more specific.

2 key fields? in one relation? 2 relations?

multikey 2 ways or what?

[milen]

Christian

thank you for the post!

Yes I was not very specific...Sorry.

Waht I want is to link 2 tables (files) by 2 key fields.

In some cases where you can't guarantee the uniqueness of any single field, you may want to designate two or more fields as the primary key.

This is my case.

In the master table I have 2 fields "k1" and "k2" - the combinataion of these 2 fiels is unique. So I want to have the same fileds "k1" and "k2" in the detail table also.

These 2 fields will link master and detail table together.

When I create a record in the detail table I want to populate somehow these "k1" and "k2" key fields

in the detail table with the values of the key fileds

"k1" and "k2" from the master table.

How I can do this with FileMakerPro 6?

If there is only one key field the tables are linked by,

there is no problem to define a relation and everything is fine.

But It seems to me that FileMaker does not

support relations by 2 or more fields.

What are my options?

Any help?

[Ugo DI LUCA]

Yes,

You can create new related records in a foreign table with a compound key.

Just set the K1 and K2 field to be lookup fields from relationship Compound Key::Compound Key.