Blacklisting

[Guest]

I hv list of blacklisted customer data in a separate table with [name] & [id]
field.

I wanted to alert user who key-in data in my main table that once the id is
matched access will pop up some msgs that the customer is blacklisted.

How should i go about it..

Thanks

 

[Joseph Meehan]

I hv list of blacklisted customer data in a separate table with [name]
& [id] field.

I wanted to alert user who key-in data in my main table that once the
id is matched access will pop up some msgs that the customer is
blacklisted.

How should i go about it..

Thanks

I suggest you start by not having two tables. I would have a black list
field (Yes-No binary). As to best get a pop up, depends on how data is
entered and how your data is stored and related.

 

[Guest]

I'm quite new to Access..

Is it possible to go about it with two tables...maybe thru some table
relationship

I hv list of blacklisted customer data in a separate table with [name]
& [id] field.

I wanted to alert user who key-in data in my main table that once the
id is matched access will pop up some msgs that the customer is
blacklisted.

How should i go about it..

Thanks

I suggest you start by not having two tables. I would have a black list
field (Yes-No binary). As to best get a pop up, depends on how data is
entered and how your data is stored and related.

 

[John Vinson]

I hv list of blacklisted customer data in a separate table with [name] & [id]
field.

I wanted to alert user who key-in data in my main table that once the id is
matched access will pop up some msgs that the customer is blacklisted.

How are you doing the match? Can you count on having the ID and being
sure that the ID is the same in the two tables?

Or, are you going to identify blacklisted customers by name? What if
there is that worthless untrustworthy schmoe Joe Doakes, and his
honest, upstanding uncle Joe Doakes?


John W. Vinson[MVP]

 

[Guest]

Yep i can count the ID or Identification Card as i may say it coz its unique
to everyone..

I hv the list of blacklisted names & IDs and to prevent myself from dealing
with this customer i want to incorporate the table in my access to alert me
when i try to create new CIF msgs will appear if the IDs is matched with the
list.

FYI the ID is unique to everyone...TQ

I hv list of blacklisted customer data in a separate table with [name] & [id]
field.

I wanted to alert user who key-in data in my main table that once the id is
matched access will pop up some msgs that the customer is blacklisted.

How are you doing the match? Can you count on having the ID and being
sure that the ID is the same in the two tables?

Or, are you going to identify blacklisted customers by name? What if
there is that worthless untrustworthy schmoe Joe Doakes, and his
honest, upstanding uncle Joe Doakes?


John W. Vinson[MVP]

 

[BruceM]

Since you are new to Access you would do well to heed the suggestion about
using just one table. You may as well start by using the program correctly.
Some of it is sort of counter-intuitive at first if you are accustomed to
spreadsheets, but you will quickly see the advantages of related fields as
opposed to copied data.

I'm quite new to Access..

Is it possible to go about it with two tables...maybe thru some table
relationship

I hv list of blacklisted customer data in a separate table with [name]
& [id] field.

I wanted to alert user who key-in data in my main table that once the
id is matched access will pop up some msgs that the customer is
blacklisted.

How should i go about it..

Thanks

I suggest you start by not having two tables. I would have a black
list
field (Yes-No binary). As to best get a pop up, depends on how data is
entered and how your data is stored and related.

 

[(PeteCresswell)]

Per zyus:

Is it possible to go about it with two tables...maybe thru some table
relationship

Many things are possible, but some of them are just bad ideas.

Is there some security consideration with the blacklist that you want to keep it
separate?

 

[Joseph Meehan]

I'm quite new to Access..

Is it possible to go about it with two tables...maybe thru some table
relationship

Possible, but why. It will end up being more work and more complex and
most likely to result in errors.

I hv list of blacklisted customer data in a separate table with
[name] & [id] field.

I wanted to alert user who key-in data in my main table that once
the id is matched access will pop up some msgs that the customer is
blacklisted.

How should i go about it..

Thanks

I suggest you start by not having two tables. I would have a
black list field (Yes-No binary). As to best get a pop up, depends
on how data is entered and how your data is stored and related.

 

[Guest]

The blacklist data are from some credit agency in the industry and i just
intend to update separate table to alert my user in the event the ID number
for my new customer are matched with the blacklist data.

 

[BruceM]

Is there a reason you do not wish to use a query in accordance with
generally-accepted design principles, as has been suggested? Add a yes/no
field to the table, add to your form a check box control bound to that
field, check the box on the form if the person is blacklisted, then use a
query that specifies True as the criteria for that field in order to produce
a listing of people who are blacklisted. Base a report on that query to
print the listing.

 

[John Vinson]

I hv the list of blacklisted names & IDs and to prevent myself from dealing
with this customer i want to incorporate the table in my access to alert me
when i try to create new CIF msgs will appear if the IDs is matched with the
list.

Then I'd agree with the other posters: a yes/no Blacklisted field in
the table is your best bet.

John W. Vinson[MVP]

 

[Guest]

Thanks

Then I'd agree with the other posters: a yes/no Blacklisted field in
the table is your best bet.

John W. Vinson[MVP]