AnsweredAssumed Answered

How to link tables and fields.

Question asked by Olex on Sep 4, 2010

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.

Outcomes