Location Table Design

[Guest]

Hi all, I am still some what new to access, please bear with me. I am trying
to come up with a table design that captures info from 5 different station
locations for aircraft. I need to capture the time sort went down, delay time
(if late), and delay code, then 2 memo fields for user to input info. What I
have so far, please tell me if I am off the path here, I am trying to make
sure that I understand/learn what I am doing.

tblAircraftLookup
AircraftNumber
ModelNumber

tblStation
IDStation
StationCity

tblSortStation
SortDate (=date() )
IDStation
SortSchd (this is a set time)
SortDown
DelayTime
DelayCode (can have up to 4 different codes)
MDelays (memo field)
Notes(memo field)

Thanks in advance for any advice you have to offer.
Steve D.

 

[John W. Vinson]

Hi all, I am still some what new to access, please bear with me. I am trying
to come up with a table design that captures info from 5 different station
locations for aircraft. I need to capture the time sort went down, delay time
(if late), and delay code, then 2 memo fields for user to input info. What I
have so far, please tell me if I am off the path here, I am trying to make
sure that I understand/learn what I am doing.

tblAircraftLookup
AircraftNumber
ModelNumber

tblStation
IDStation
StationCity

tblSortStation
SortDate (=date() )
IDStation
SortSchd (this is a set time)
SortDown
DelayTime
DelayCode (can have up to 4 different codes)
MDelays (memo field)
Notes(memo field)

Thanks in advance for any advice you have to offer.
Steve D.

Well? Is it working???

The DefaultValue property of SortDate should be Date(), I presume that's what
you mean. I have no clue what "sort" means in your context nor what "time sort
went down" might mean.

If you're having a specific problem please describe it - I'm not even sure
what you're asking.

John W. Vinson [MVP]