Hi there

I was asked by my company to sort out some shared excel workbook problems
and I thought I'd give access a try.I created 3 tables each being linked to
one another and then created a data access page.My question is can you run a
active query on a field  that constantly searches the table to see if the
value exist.If the value exist then it should fill out(or grey out) all
fields from the same table.I would not like that specific table to grow with
redundant data and i also would not like people calling me every second
because their page recieves an error about duplicate values.

Any help would greatly be appreciated.
Thank You