Re: About my Database

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

Hi Robert!
It looks to me like you might have a structural problem - I'm not sure that
all your tables are
built properly. Do you need all those tables? I agree that there was no way
that you could do anything
with one big table but could you not manage with the Basics table and one
other table for all the details?
Without all the information it's a bit hard to see the whole picture but
here's where I'd start:
- make the Basics table the Master with key on SSN
- make the other tables Detail-tables with key on SSN + id field
- define all relationships on SSN in each detail table and SSN in master
(it's like Orders and Order_details in the Microsoft Northwind database)
- then you can create a Details form with subforms for all the other tables
so that when you enter SSN in the master, it will be entered into the
details,
again like Order# in the Orders form

Anyway, hope this helps to get you started.
Good luck!

Mike L
I have a free tutorial on Access that you might want to check out.
It's at www.profsr.com Profsr.com Tutorials




"Robert" <wukichra@xxxxxxxxxxx> wrote in message
news:1113315616.635679.300530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello Again Everyone
>
> As mentioned earlier, I would probabally be posting a great deal. Here
> is the overview of my database and a subsequent problem I am having.
>
> Initially, there was one HUGE table, now I have several tables, these
> are named as follows:
>
> These are tables that are referenced by autolookup fields
>
> LstBldTyp
> LstClnc
> LstGndr
> LstKeyBilletO
> LstRankList
> LstSwimClass
> LstWorkSection
> LstWpnsQual
>
> These are tables that contain data
>
> TblG3Account
> TblG3Basic
> TblG3Clnc
> TblG3Med
> TblG3NoK
> TblG3NonResPME
> TblG3OIF0406TrngALL
> TblG3OIF0406TrngSel
> TblG3Promo
> TblG3Recall
> TblG3ResPME
> TblG3Skills
> TblG3Training
> TblG3Uniform
> TblG3Vehicle
> TblG3Weapons
>
> I use the TblG3Basic as (what I consider) my master table with the
> basic information. I am using a MbrSSN field (Social Security Number)
> as the master key and as my reference for all relationships on a one to
> one basis.
>
> When I open my TblG3Basic, I do not see any of the sub datasheets,
> Trying to figure out why that is. Also as I said, I use my TblG3Basic
> as the starting point, I am trying to figure out how to get it so that
> when I enter a social security number in, it cascades through all of my
> other tables (creates a new record I guess). I have referential
> integrity and cascade update and delete, but for some reason I still
> have to enter the SSN's manually...
>
> Any help would be appreciated, if you need more information, please let
> me know!!
>
> Robert A. Wukich, Sr
> Sgt/USMC
>


.

Relevant Pages

  • Re: About my Database
    ... I believe it is a structural problem, ... The way around this right now is for me to plug in the SSN manually ... > - make the Basics table the Master with key on SSN ...
    (microsoft.public.access.gettingstarted)
  • Re: How to authentificate an user via telephon?
    ... >>the last 4 digits of the users ssn & birthdate against our ERP software. ... >>Robert Sieber wrote: ...
    (Security-Basics)
  • Re: Help needed with query design
    ... Ok so SSN should uniquely identify the records. ... The SQL to show Master Records that have been dropped would be ... In the query grid ... Each Members records can change ...
    (microsoft.public.access.queries)
  • Re: MS Project MPP File Large
    ... Robert wrote: ... have one administrator keeping the schedule up to date. ... archive and then collapsing the remaining file. ... master and sub master files. ...
    (microsoft.public.project)
  • Re: About my Database
    ... Forms -- Display data, add data, edit data, and sometimes ... The way around this right now is for me to plug in the SSN manually ... >> - make the Basics table the Master with key on SSN ...
    (microsoft.public.access.gettingstarted)