It would be good if a function similar to DLOOKUP in VBA could be available. I’d like to pull data from another table, but can’t if it’s not linked. As an example - I have a series of events at which people can hire things. They pay for a number of hire periods. In the table that lists the hires I can select an event, but then I can’t look up the event at which they should return it, even though I can calculate the reference of that event.