Table to link to not showing in selection choices

[Jan_Miller]

I have one Patient table with fields for Email address, Patient name, and Contact info.
I also have a Visit Detail table that I am trying to link to the Patient table by matching the Email address, then looking up the matching Patient name.

The problem I am encountering is that when I attempt in the Visit Detail table to make the link in the “Customize Field Type” of the Email Address or Patient name of the Visit Detail table, the drop-down list of tables to select from does not include the Patient table. In both tables, the Email Address field uses field type of “email”.
Patient name is single text in both tables.

[ravi_gidwaani]

Hello Jan,

Hello,

Feel free to DM me to setup initial free introductory call to discuss your needs with our Airtable specialist and find out how you can best achieve your automation and data management goals.

We can help you automate your systems while providing you with a very user-friendly interface and data organization

Can I schedule a time for you to speak an initial free introductory call to discuss your needs with our Airtable specialist and find out how you can best achieve your automation and data management goals?

We have already helped more than 100 clients move to the software for the first time, improve their current Airtable set-up.

E-mail : ravi@alessiomonino.com

Website : https://alessiomonino.com/

Schedule Free Introductory call: Calendly - Alessio Monino

Love & Respect

Ravi Gidwani

[kuovonne]

Welcome to the Airtable community!

Can you share a screen shot of what you are seeing?

In Airtable, linked records are linked using the primary field (the left-most field that cannot be hidden).

[Jan_Miller]

Hi [kuovonne],
Thank you for your help. I did some more reading and then created an “Id Field” as CONCATENATE({Name (from Client)},Date). That provided me with a means of identifying unique Client visits.

I am coming from a SQL/PHP background, so I am trying to learn the AirTable Functions syntax. Could you help me with a really basic question? In SQL,
“SELECT *” is used to pull all the records in a table, and can be modified with the “WHERE” statement. Is there a Function that will pull up all the records from a table and display them in a field?

My AirTable project is intended to allow a hypnotherapist to select a table of specific questions to ask a patient (“Client”) based upon a specific Cause value from a table of Causes. Each Cause has its own corresponding table of questions. So; I would like to retrieve all of the questions from that specific table based upon the selected Cause.

[kuovonne]

Jan_Miller:

I am coming from a SQL/PHP background, so I am trying to learn the AirTable Functions syntax.

Airtable linked records work very differently from a SQL database. Airtable does not have the equivalent of a SELECT * WHERE ... statement. Airtable also does not use “primary key/ foreign key” architecture. Instead all links are made to a record as a whole, not a particular field. There is also no automatic linking based on matching values (unless you create an automation that creates the link).