Adding Multiple Subforms

[Newbie and Lost]

I am trying to create my first database and I am having some issues with the
subforms. I created the main form using an existing table and now I want to
show multiple subforms down below. I can insert the first subform but since
I want to have mutiple subforms I need the subforms to show up on tabs verses
seeing all subforms at the same time. When I created the tabs and added a
subform to each tab I thought it would work but the view looks wrong (the
page doesn't scroll correctly) and it somehow created two records for the
same employee because that employee was located on two different teams (on
the Teams Assigned subform). Is there a property that needs to be changed or
I am doing this completely wrong?

 

[John W. Vinson]

On Tue, 16 Dec 2008 13:30:01 -0800, Newbie and Lost <Newbie and

I am trying to create my first database and I am having some issues with the
subforms. I created the main form using an existing table and now I want to
show multiple subforms down below. I can insert the first subform but since
I want to have mutiple subforms I need the subforms to show up on tabs verses
seeing all subforms at the same time. When I created the tabs and added a
subform to each tab I thought it would work but the view looks wrong (the
page doesn't scroll correctly) and it somehow created two records for the
same employee because that employee was located on two different teams (on
the Teams Assigned subform). Is there a property that needs to be changed or
I am doing this completely wrong?

I don't see why you would need multiple subforms. Are they all more or less
indentical? Are they all based on the same table (with a TeamID field), or do
you have a separate table for each team (bad idea)?

It all starts with the tables. If you started with Forms, you may be painting
yourself in a corner! What is your table structure?

 

[Newbie and Lost]

I am creating a database to track the employee info as well as invoice orders
from multiple markets or clients of whom all have a different invoice that
they send over in different structures (i.e. client 1 send over a spreadsheet
with the products on seperate rows where client 2 sends every product listed
on one row) Since our clients our different companies that we make sales for
it is very hard to get them to change the reporting process on their end so
we have to adapt each different clients invoice.

The tables I have are:

Employee Info- Your usual employee info table
Team Assignment - Since they are sales reps they are often juggled from one
team to another so to ensure that the correct manager receives the correct
overrides all Team assignments for one agent are tracked in this table
Badges - Each system requires a badge number and this helps to link the
sales to the correct agent but again since the agent may work for client 1
one week they might switch to client 2 and then back to client 1 so I need to
be able to have multiple badges for each agent.
Manager Overrides - This is to identify what teams a particular employee
oversees and what their percentage is for each team. If they are a General
Manager then it is usually just one team but if it is a Regional Manager they
may oversee 10 different markets that have ten different General Managers.

All of these are linked by the Employee ID. What I would like to be able to
do is enter a new Employees Info on the parent form and then enter their Team
Assignment, Badge and Manager Override on the multple child forms below.

I hope that wasn't too long winded and made sense.

 

[John W. Vinson]

All of these are linked by the Employee ID. What I would like to be able to
do is enter a new Employees Info on the parent form and then enter their Team
Assignment, Badge and Manager Override on the multple child forms below.

Fine; what problem are you having? I've built forms with ten or more subforms.
Note that when you put a subform on a tab page you must be sure to select the
page upon which to put it - the page will darken; if you just drag a subform,
it will appear *in front of* the Tab control, and will logically be on the
mainform (you can tell because it is visible no matter which tab you select).
If this happened, select the subform control; type Ctrl-X to cut it to the
clipboard; select the desired tab; press Ctrl-V to paste it onto that page.