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
-
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:
and
Just select the required field(s) from the Property.
-
@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...
Content aside
- 5 yrs agoLast active
- 2Replies
- 1265Views