Re: table structure questions

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

On Fri, 30 Jun 2006 16:00:02 -0700, tjr
<tjr@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:


Lets start with one thing at a time shall we? I do appreciate any and all
suggestions and will implement them all and see what works.

How am I going to go about entering multiple schedules where each step must
be marked as complete and then marked again as paid.


should each banks schedule be it's own table or should each schedule be a
record in the banks table?

Neither. I'm not sure what a "schedule" means in this context, but if
each Bank has multiple steps, and each Step may be completed for
multiple banks, then you have a "many to many" relationship, which
needs THREE tables:

Banks
BankID
BankName
<other info about the bank>

Steps
StepNo
Description
Cost <if that's appropriate>

Actions
BankID <link to Banks, who's doing the step>
StepNo <what are they doing>
StartDate <or date/time if that's appropriate>
Completed <yes/no>
Payment <currency or yes/no>

You'ld use a Form based on Banks with a subform based on Actions; each
step would be one more record in the Actions table.

I would appreciate the help. I admit to not knowing a ton about access but
I have read access inside out and am re-reading it to grasp the more
difficult topics.

Our company is just a year old and is growing by leaps and bounds. We
simply can not invest in anymore software.

That is why I am trying so hard to learn access. Do you have any suggestions
on the design for the schedules table/s?

I suppose I can just insert a hyperlink field to the one note page, but I
just can't begin to conceptualize how this would be simplest to set up.

That would be a LOT more complex, IMHO.

Check out the links at http://www.mvps.org/access and/or at
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html,
especially the Database Design 101 links.

John W. Vinson[MVP]
.

Relevant Pages

  • Re: table structure questions
    ... the schedules that I deal with. ... Exterior and Interior walls complete ... Nov where tjr and i discussed his process at some length. ... record in the banks table? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Queuing theories
    ... Dan Freeman wrote: ... Most banks have a single queue for multiple teller windows ... I, too, thought of banks, the Post Office, and Fry's as exceptions to the general rule of multiple lines/registers. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: table structure questions
    ... Tina and or John, ... the schedules that I deal with. ... Exterior and Interior walls complete ... record in the banks table? ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Remove Data Duplication
    ... >ServiceDetail fields. ... There will be one Department for multiple Divisions, ... >Multiple Banks for each Division, Multiple Services for each Bank and so on. ... Banks, a fourth table for Services, and a fifth table linking Banks to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: table structure questions
    ... How am I going to go about entering multiple schedules where each step ... record in the banks table? ... John W. Vinson ...
    (microsoft.public.access.tablesdbdesign)