How to link tables and fields.
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.