AnsweredAssumed Answered

RELATED TABLES

Question asked by andreapp on Jan 31, 2011
Latest reply on Feb 1, 2011 by philmodjunk

Title

RELATED TABLES

Post

HI!

I'm trying to manage a Database with different tables related. I would like to have a main table with all my contacts and the same information in different tables by one category. I mean:

TABLE 1_ DATABASE : suppliers, clients and freelances' details

TABLE 2 _ FREELANCE: just the records which contents the category FREELANCE

TABLE 3_ SUPPLIERS: just the records which contents the category SUPPLIER

TABLE 4_ CLIENTS: just the records which contents the category CLIENT

Is it possible??? Can anyone help me?

Thanks

Outcomes