|
Home > Archive > MS Access database support > February 2006 > A2k - what the hell is TID?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A2k - what the hell is TID?
|
|
| Deano 2006-02-19, 11:23 am |
| This is something I've not bothered to learn about but I see it in Append
queries everywhere e.g
TID: [forms]![frm_Input]![id]
What precisely does this refer to?
| |
| Anthony England 2006-02-19, 1:24 pm |
| "Deano" <deano@mailinator.com> wrote in message
news:43f89c09$0$9239
$ed2619ec@ptn-nntp-reader01.plus.net...
> This is something I've not bothered to learn about but I see it in Append
> queries everywhere e.g
>
> TID: [forms]![frm_Input]![id]
>
>
> What precisely does this refer to?
With queries you can create extra columns using an alias. So if you had
tblContact with fields FirstName and LastName, then you could add a new
column where you write:
FullName: FirstName & " " & LastName
In other words we define a column called FullName, which isn't a field in
the table but nevertheless is shown as column in the query. Notice how it
is defined with the use of a colon.
In your case, a value is being defined as TID which is being looked up from
an open form called frm_Input. We can't really say much more than this, but
whoever designed the database is using the form to persist some value.
| |
|
| Anthony England wrote:
> "Deano" <deano@mailinator.com> wrote in message
> news:43f89c09$0$9239
$ed2619ec@ptn-nntp-reader01.plus.net...
>
>
> With queries you can create extra columns using an alias. So if you
> had tblContact with fields FirstName and LastName, then you could add
> a new column where you write:
> FullName: FirstName & " " & LastName
> In other words we define a column called FullName, which isn't a
> field in the table but nevertheless is shown as column in the query.
> Notice how it is defined with the use of a colon.
>
> In your case, a value is being defined as TID which is being looked
> up from an open form called frm_Input. We can't really say much more
> than this, but whoever designed the database is using the form to
> persist some value.
Ok cool, thanks for the explanation. Yes, I didn't write half of the
queries in my database so when I come to review stuff i get a bit confused
:)
|
|
|
|
|