Table Realtions

Dean_Axon

Let me try to explain it ....

In Table 1 I have a table relation to Table 2. The relation is also to the primary key of table 2.

so, if I change the primary key on table 2, what do I need to set to get the value posted in table 1 to change ??

I thought that if there was a table relation to a field, then that value was automatically changed. :oops:

Any ideas ??

jm

Hi Dean,

do you realy change the primary key on table 2,
or do you change the "primary key"-field on one record of table 2?

br
Josef Metz

Dean_Axon

do you realy change the primary key on table 2,
or do you change the "primary key"-field on one record of table 2?

I change the primary key field of the record on table 2

Dean_Axon

Maybe I can explain it better with an actual example.

Table 32 - Item ledger Entries has a field "Item No.". This has a Table relation to Table 27 - Item.

If I change the "No." on the Item table, then Navision will automatically change the item ledger entries on table 32 to show the new item code.

How do I make sure thatthis happens on fields that I create ??? Does it have to form part of a key or the primary key ?

jm

Hi Dean,

i think that the table relation in table 1 to table 2 (primary key) is enough.
the field will be changed,

but the primary key of table 2 should consist of one field.

Do you realy rename that primary key field of table 2 in a form?
Rec.MODIFY will do no rename.

br
Josef Metz