Getting info from related field

[Rense]

This is my first filemaker experience so bear with me :

I want a field to be autofilled with an number.

This is what I have.

I have a table called system with a field account

I have a table called personel with a field account and a field pID

I have a table called hours with a field pID

the system::account is filled with a name.

When a new record is made I want the hours::pID to be filled with the pID from where personel::account = system::account

My guess is that I should make a calculation but I just can't figure out how...

[bcooney]

Welcome to the Forums, Rense.

You have a few options and it depends on your needs.

1. Use the Lookup entry option to copy the value from one table to another using the relationship between them. Use this if the value must remain the same. For example, in an invoicing solution, Lookup is used to copy the product's selling price at the moment of sale.

2. Simply show the related field. You can include fields from related tables on your layout.

3. Create a calculation field in one table that equals the related table's field. (Not really needed, just do #2).

But, I must point out that you are best served by not relating two tables by matching text fields that contain names. Names change and so the relationship will break. Instead use key fields that are auto-entered serial numbers.

Please take some time to read this paper . I think it'll help you establish a strong foundation in FM.

[Rense]

Thanks for the welcome, i choose to just start over from scratch using more ID's.

I'm still ajusting to the FM way of thinking :D