Card Accounts

[James]

I have a data base that need to track 4 different card account all of the
account are basically the same just for diffent items. (ie, b&w copies,
color copies, faxs, etc) I have to forms for each account (8 total) each
has five field: ClientID, EmpID, Add (or Remove depending on form),
comments, and date. I have four diffent tables one for each item. Is this
the best way or is there a better way to ensure integraty. The only fields
that the user has to fill out are EmpID, Add (or remove), and comments.

 

[Tim Ferguson]

I have four diffent tables one for each item. Is this
the best way or is there a better way to ensure integraty.

If they are different types of the same things, then keep them all in the
same table. It would seem to me that you could do all this with one form,
but that of course is up to you.


HTH


Tim F