Multi Group Dbase

[Mike C.]

Happy Holidays All!

I am in the process of designing a database that will allow 4 different
groups of users to utilizie it. (Basically 4 different databases in 1).
Group A will fill in a form(s) collecting certain information. Group B will
utilize the exact same form(s) to fill in their information and the same for
Group C and Group D.

I will set up a switchboard that will allow the user to select "Group A",
"Group B", "Group C" or "Group D" and it will then open the appropriate form
with the appropiate data in it.

What is the best and most effecient way of accomplishing this? I'm
wondering if I can avoid having to use a table structure like below:

tblGroupASection1
tblGroupASection2
tblGroupBSection1
tblGroupBSection2
....etc

Thanks in advance,

Mike

 

[Duane Hookom]

I can't imagine a situation where four different groups would need to
enter/edit records in the same table at the same time for the same record.
Can you share something about your table structures?

 

[TC]

You don't design your tables based on how you want the forms to look.
You design your tables to reflect the logical relationships of the data
that you need to store. Then you use queries, subforms, or other
techniques, to present the data (visually) in the way that you want.

So, /forget/ the forms for the moment. Tell us what data you need to
record, and what tables you think you will need to record it.

For each table, be sure to identify the "primary key" (PK). If you
don't know what a PK is, you need to stop now, and read-up on a topic
called ":database normalization", before you go any further. Google
that term on the web, you should find lots of articles.

HTH,
TC