How to link tables and fields?
Hi all. I have a customer's database with multiple fields. I want to create a payment receipt with receipt number (that's being increased with each new record). So I created new table and copied all fields I want to be displayed on the receipt from the main table. Then i created relationship between same records in these two different tables. But unfortunately every time when I create new receipt/records on the receipt table It doesn't display the related fields, such as name, address and so on, the only thing it displays is the new receipt number. How can I import data from main table (current record) into "receipt" table. I've even tried "Set Field" to equal value from the main table but nothing is coming through. Thanks in advance. Any help would be appreciated.