Forum Discussion

Boycie92's avatar
Boycie92
Icon for Resolver I rankResolver I
5 years ago
Solved

Data Model

Hi,   I have a data modelling issue I am hoping some can help with.   I have 4 Tables: A Date Table A look up table containing the Building and Area And Two other separate Tables (Table 1 & Ta...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • pmay's avatar
    pmay
    5 years ago

    Make your relationship between the lookup table and Table1 & Table 2 single-direction (lookup filters Table 1 & 2), and ensure it is single-to-many.  

    Then I think you will be able to add the relationship between your calendar & Table 1, 2.

pmay's avatar
pmay
Icon for Resolver I rankResolver I
5 years ago

Make your relationship between the lookup table and Table1 & Table 2 single-direction (lookup filters Table 1 & 2), and ensure it is single-to-many.  

Then I think you will be able to add the relationship between your calendar & Table 1, 2.