A2k - what the hell is TID?

[Deano]

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]

"Deano" <de***@mailinator.com> wrote in message
news:43**********************@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.

[Deano]

Anthony England wrote:

"Deano" <de***@mailinator.com> wrote in message
news:43**********************@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.

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
:)