Table Realtions

Dean_Axon
Dean_Axon Member Posts: 193
edited 2004-10-12 in NAV/Navision Classic Client
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 ??
Remember: Keep it simple

Comments

  • jm
    jm Member Posts: 156
    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
    br
    Josef Metz
  • Dean_Axon
    Dean_Axon Member Posts: 193
    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
    Remember: Keep it simple
  • Dean_Axon
    Dean_Axon Member Posts: 193
    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 ?
    Remember: Keep it simple
  • jm
    jm Member Posts: 156
    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
    br
    Josef Metz

Categories