0 Replies Latest reply on Sep 4, 2010 1:08 AM by Olex

    How to link tables and fields.

    Olex

      Title

      How to link tables and fields.

      Post

      Hi all,

      I have a customer database with multiple fields.

      I want to create a receipt with a new receipt number (that is being increased with each new record).

      So far, I 've created new table (receipts) and copied all fields I want to be displayed on the receipt from the main table. Then I created a relationships between same two fields in two different tables.

      But every time I am going to create a new receipt in "receipt" table, it doesn't copy data, such as name, address etc from the current record in the main table.

      I even tried to use "Set Field" to the same value  as the main table but nothing is coming through.

      Any help would be appreciated.