Can I do this in a data access page?

[Guest]

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

 

[Keith Wilby]

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.

Are you saying that one field should contain no duplicates? If so then you
can set this at table level. Open the table in design mode, move to the
field in question and change the "indexed" property to "yes (no
duplicates)". Sorted.

Keith.
www.keithwilby.com

 

[Guest]

or use a delete query to delete duplicates