New tables/queries/forms etc. based on existing format?

[bfdeal31]

Hi,
I have created a series of relationships, tables, queries, and forms in a database for keeping track of the invoices for one particular client company. Is there an easy way to quickly duplicate all of those relationships, tables, etc. for use with a different client company? Basically I want to take my existing format and copy it to use for other, seperate client companies and store them all in the same database. So far I have been copying/pasting/renaming/ and editing, each individual query/form/table and my progress is very slow. I was wondering if there was perhaps a way I could design a template or use a wizard to do the tedious work? I appreciate any help and can clarify my situation further if needed. Thanks.

Steve

 

[Shane_Mc]

You seem to be going about this all wrong!

Why do you need all these extra things. You will make a real mess of your relationship diagram with all that stuff.

You should only need one of each table, one of each form etc.

It sounds like you are trying to isolate all your different companies. A query will do that for you! What happens if next year you decide to add another company? You have to copy and paste all that stuff again.

I think you should clarify why you need all that stuff? Maybe I'm picking you up wrong here.

 

[bfdeal31]

Shane,
Thank you. That makes a lot of sense. I can't believe I didn't think of that before. It's like a light bulb just came on. I guess the best way to differentiate between the different invoices is to add a "Company Code" field or something like that. I feel kind of dumb now but once I get this mess all straightened out, you'll have saved me a lot of time and hassle in the long run. Thanks again.

Steve

 

[Shane_Mc]

Not a Company code.......a company table.

Remember, you only want to store any information (name, address, phone no. etc.) about the company once. Create a company table and link this to your invoices table with a one to many relationship.

 

[bfdeal31]

Thanks.

Shane,
I took your advice and made a seperate company table and related it to my existing tables through a one-to-many relationship and it works great. Thanks for your advice.

Steve