Multidimensional Database Question (Foreign Key)


I have two tables with the following columns

  • jobs ( job id, client id(client table lookup), job dollar amount)
  • clients (client id, first name, last name, email address, company)

If I’m looking at my jobs table, how do pull in the email field from the clients table based on the selected jobs.clients(lookup) field?



If I understand your question correctly, then try this:

Create a column in [jobs] table called [client email]. In that column type: [client id].[email address]. This looks up the client based on the [client id] value in the row and then using dot notation, it accesses columns in the [clients] table, in this case the email column.




Works like a charm! Thanks @Ander