Hi all

I have a table, where there's AutoID, Name of Person (looked up from
tblPerson), Name of Dispute (looked up from tblDispute), Date, Details
(Memo). What I have is another table that need to look up to records in
this table, but I couldn't because Access wouldn't let me look up just
an AutoID on its own...

So I created a new field in the table called Title. On the form it's
basically =[Dispute]+[AutoID]; I can get it to work ok on the form but
how can I get the end result of this to automatically appear on the
table field for the lookup?

I'm very much a novice so please accept my apologies if there's a really
simple answer to this!

Thanks for your time and help!

Best wishes
Will

Will wrote:

Hi all
>
I have a table, where there's AutoID, Name of Person (looked up from
tblPerson), Name of Dispute (looked up from tblDispute), Date, Details
(Memo). What I have is another table that need to look up to records in
this table, but I couldn't because Access wouldn't let me look up just
an AutoID on its own...
>
So I created a new field in the table called Title. On the form it's
basically =[Dispute]+[AutoID]; I can get it to work ok on the form but
how can I get the end result of this to automatically appear on the
table field for the lookup?
>
I'm very much a novice so please accept my apologies if there's a really
simple answer to this!
>
Thanks for your time and help!
>
Best wishes
Will

sounds like you use Excel and think Access should work the same way.
Newsflash. It doesn't. use queries. Lookups are the work of the
devil. And do not store calculated values. you can't get lots of
things to show up programatically in a table because Access is not
really designed that way. You should use queries if you want to create
expressions or combine data from different tables. That's what they're
for.