I need to know how and where to input information in a file that will be "connected" to another file so that when I type an item number, then the description, cost, and quantity in stock will appear.

Edited April 16, 200817 yr by Guest

You have to make corresponding fields in 2 tables... For example:

Table Invoice has: invoice_id, [color:red]customer_id, date, etc.

Table Customers has: [color:red]customer_id, name, address, etc.

You then have to make a 'Relationship' between Table Invoice and Table Customer with [color:red]customer_id.

sample.fp7.zip

Edited April 17, 200817 yr by Guest
Added a sample...