Course Number Generated by User input in two previous fields

[Sean_Lake1]

Hey all,
I have been testing out online DB’s, Knack, e.g., and created a formula to take three fields from inside the table and it generates a complete course number. Each of those fields were connected to their own tables.
The formula wound up being a text formula is:
{ILT Course Course Level.Course Level Number}{ILT Course Course Types.Course Code}.{Sequence Number}

How can I do this in AT? I’ve seen the formula option for a field, and even the Link to another Field(tab/table) option so it seems it’s possible, but when I attempt it I don’t get exactly what I was expecting. I get NaNa, or something like that LOL.

Any ideas?

[Justin_Barrett]

Sean_Lake1:

Does this help, Justin?

That’s the lookup field. I was asking for the setup for the {Course Type} link field itself. However, I think what I really wanted to see (which is, of course, impossible, so just ignore my request) was your original setup before you began making changes. Some of your earlier screenshots seemed to conflict. The screenshot showing a link looks one way, but the screenshot of the table related to that link looks completely different.