AutoLookup or maybe other feature HELP>???

[skiflyer45]

I'm trying to establish a ticket/citation database for a college security office at which i work at. I have two tables, table 1 includes the ticket information (date of ticket, citation number, *tag #, amount etc.), table 2 includes Repeted offenders information such as (name, address, city, zip, phone number, student ID# etc.).
I would like to have a table or query(preferably table) which automatically matches tag#'s to student information as soon as a new ticket is entered, *if the student information is available.
Thanks a lot in advance

 

[FoFa]

You could use a subform to display that information tied to the proper key field entered in conjuction with a refresh.
You could use a lookup (either some dlookup's or a VBA) to pull and populate.
These would be at the to of the list.

 

[skiflyer45]

ok thanks.....could you or someone maybe do a quick step by step how I would do this?
Thanks

 

[skiflyer45]

anyone????