AnsweredAssumed Answered

Data not visible in a related table.

Question asked by p_pohlhammer on Nov 2, 2015
Latest reply on Nov 2, 2015 by coherentkris

My Filmmaker DB has tables for ORDERS, OrderDetails, and BUDGET related so that OrderDetails is a join table,between the other two. It is related to Orders by OrderID_fk, and to BUDGET by BudgetID_fk. In the relationship graph I created another occurrence of the join table called Ordered_BUDGET and related it to the BUDGET table again by BudgetID_fk. When I open a layout based on Ordered_BUDGET the layout shows that there are 2593 total records (the correct number), but many of the later entries show as completely blank. All records are visible in the original table. What would cause this?