Layout with multiple tables is not displaying all records
I have a layout displaying fields from three related tables. For some reason the layout only displays the records in fields that are related from one of the tables.
For example---the tables salesdata, inventory and customers--sales data and inventory are related through a field called item id. I want the field in the inventory table called "description" to display with the item id info from the table sales data. The field is there on the layout buy the records are blank.
What should I look for?