Re: Adding Multiple Subforms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" wrote:

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

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?

--

John W. Vinson [MVP]

.

Relevant Pages

  • input and display on another form
    ... A client comes in enters their client ID, ... I have a second form that an employee takes the client ID and inputs ... My client page has 7 subforms. ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... You probably need to read-up about the topic of database "normalization". ... > Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ... > the Display Control, ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... rules of normalization in mind as I revise this database. ... Pharmacies, etc., however, my repeated replication of the entire database ... >> Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ...
    (microsoft.public.access.forms)
  • Re: Huge database weighs heavily on small brain
    ... separate tables for the current and each review period. ... Regarding the combo boxes as subforms, ... For example, the Client Brand Drug ... the Display Control, ...
    (microsoft.public.access.forms)
  • Re: Analyzing/Normalizing Database
    ... and other attributes of the employee - for example: ... Now, as I understand it, a contract is arranged with a client (may be ... If each employee has multiple possible pay rates, ...
    (microsoft.public.access.tablesdbdesign)