One product table of three product tables

[Guest]

Dear all,

I am developing a simple database for our company. My company have
three product lines, let it be A, B, and C. Different colleagues will be
responsible to the corresponding products. As I know user management in
Access is basing on table, will it be better to use three product table A,
B, C for user management purpose? Or can I use one product table and let
the user use only form to access the tables?

Thanks for any suggestion!

Best regards,
Teres

 

[Michel Walsh]

Hi,


If the data structure is the same, one table, since you would probably
have to combine/compare/check/consolidate/cutAndPaste among all the "three"
tables, otherwise, at a moment or at another one.

Just add the extra field "Project" (with possible values "A", "B", or "C" )
to the unique table, add the WHERE clause: WHERE Project="B" to get the
sub-set about project B only, or remove the criteria to get the whole view
of what the company is doing, etc. Much more versatile, and in the spirit of
SQL (where TableName canNOT be argument, but "data" value can).



Hoping it may help,
Vanderghast, Access MVP