By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,214 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,214 IT Pros & Developers. It's quick & easy.

A2k - what the hell is TID?

P: n/a
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?
Feb 19 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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.
Feb 19 '06 #2

P: n/a
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
:)
Feb 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.