D
dhstein
We have a database that includes a product table. This has all information
about the products including costs and the database has many functions. We'd
like to provide a way of allowing the customer service people to keep some
product notes about the products without being able to see all the other
fields. In addition, they don't need - and shouldn't have - all the other
functions. I was thinking about providing a totally separate database with
just the product information and a comment field. But I'd like the ability
to keep the database in synch with the master so that when new products are
added the customer service people will have those items also. So two
questions:
1) Is my approach the right one or is there a better way.
2) If this is the right approach, how could I set it up so the products are
in synch?
Thanks for any help on this
about the products including costs and the database has many functions. We'd
like to provide a way of allowing the customer service people to keep some
product notes about the products without being able to see all the other
fields. In addition, they don't need - and shouldn't have - all the other
functions. I was thinking about providing a totally separate database with
just the product information and a comment field. But I'd like the ability
to keep the database in synch with the master so that when new products are
added the customer service people will have those items also. So two
questions:
1) Is my approach the right one or is there a better way.
2) If this is the right approach, how could I set it up so the products are
in synch?
Thanks for any help on this