0

Tables and linking

I have a table called 'Accommodation' - this is a reference table of various properties around the world.

I have another table called 'Trip' that has various sub tables (each one is a separate element it takes to build a trip). One of these sub-tables is called 'Accommodation costing'.  What I'd like to know is how to SELECT a property (this I can do) and then have various detail that is under that record; such as nett rate, property description, contact info etc automatically appear.

 

Thanks

2 replies

null
    • Database Consultant
    • Kirkness_Associates_Ju
    • 4 yrs ago
    • Reported - view

    This is quite straightforward - in the Accommodation Costing table (a subtable of Trips) create a link to Accommodation then use formula fields to pick up the values from the Accommodation record:

     

    Screenshot 2019-05-01 at 15.14.35

     

    and

     

    Screenshot 2019-05-01 at 15.15.10

     

    Just select the required field(s) from the Property.

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Julian... while your recommendation is correct... I would suspect the data model would also have date range sensitivity .. to pick the appropriate rate for the appropriate date... 

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1265Views