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]

Re: A2k - what the hell is TID?

"Deano" <deano@mailinat or.com> wrote in message
news:43f89c09$0 $9239$ed2619ec@ ptn-nntp-reader01.plus.n et...[color=blue]
> 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?[/color]


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]

Re: A2k - what the hell is TID?

Anthony England wrote:[color=blue]
> "Deano" <deano@mailinat or.com> wrote in message
> news:43f89c09$0 $9239$ed2619ec@ ptn-nntp-reader01.plus.n et...[color=green]
>> 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?[/color]
>
>
> 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.[/color]

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