Is there a function that works like vlookup or a way to relate tables by matching fields?

Is there a function that works like vlookup or a way to relate tables by matching fields?

The "Looked Up Column" data type is neat, but not exactly what I'm looking for.

I'm starting with a simple task in order to learn how to use Zoho DB & Reports.  I have 2 tables:

Appointments to View Apartment:
ViewNo. (Auto Number), Contact Date, First, Last, Phone, Date to View, Time to View

and

Rental Applications:
AppNo. (Auto Number), ViewNo. (Looked Up Column), Date, First, Last, Phone, etc.

In Rental Applications, I want "First", "Last", and "Phone", to automatically fill in once the "ViewNo." is chosen.

If I just define "First", "Last", and "Phone" to all be Looked Up Columns, besides having to enter information that should be done automatically, there's the problem that they don't even have to come from the same record.  A user could enter ViewNo. 3, but enter "First" from record 2 and "Last" from record 4 and "Phone" from record 1.  I know full relational database functionality isn't available yet, but what about vlookup that does something similar in spreadsheets?  Is there a vlookup function?