Duane Hookom said:
You can take the time to type the structure into a message like:
Table 1
SWIIM MEET
SwimeetingID
[Primary key Autonumber]
Type [ex club or school] ((text)
[Lookup table H]
Venue (text)
Start time [like 14H00] (text)
Date of meeting (date/time)
Year [calculated from above] (number)
Age date [to determine age of swimmer]
(date/time - formatted to 00/00/0000)
Memo [for relevant information] (memo)
OrganizerID [number]
TeamID [number]
EventID [number]
Table 2
ORGANIZER
OrganizerID [Primary key Autonumber]
Institution (text)
Contact title (text) [Lookup table F]
Contact name (text)
Contact surname (text)
Contact home phone (text)
formatted as 000 000 0000
Contact work phone (text)
formatted as 000 000 0000
Contact cell phone (text)
formatted as 000 000 0000
Contact fax number (text)
formatted as 000 000 0000
Contact personal e-mail (text)
Organization e-mail (text)
Address 1 (text)
Address 2 (text)
City/Town (text)
Code (number)
PO Box (text)
PO Box Code (number)
Head of institution (text)
Memo (memo)
for relevant information
Table 3
TEAMS
TeamID [Primary key Autonumber]
SwimmerID (number)
Institution (text)
Team name - full name] (text)
Team abbreviation (text) [ex. VRED]
Teem title (text) [Lookup table F]
Teem name (text)
Teem surname (text)
Teem home phone (text)
formatted as 000 000 0000
Teem work phone (text)
formatted as 000 000 0000
Teem cell phone (text)
formatted as 000 000 0000
Teem fax number (text)
formatted as 000 000 0000
Teem personal e-mail (text)
Organization e-mail (text)
Address 1 (text)
Address 2 (text)
City/Town (text)
Code (number)
PO Box (text)
PO Box Code (number)
Head of institution (text)
Team payments (currency)
Memo (memo)
for relevant information
Table 4
SWIMMER
SwimmerID [Primary key Autonumber]
TeamID (number)
Swimmer name (text)
Swimmer surname (text)
Birth date (text)
Age (text) [datediff [Birth date].[Age date]
Entry time (text) [formatted as 00:00,00]
Event time (text) [formatted as 00:00,00
Heat (text)
Lane (text)
Position (text) [determine by query]
Points (text) [determine by query]
Language (text) [lookup table E]
Comment (text) [lookup table I]
[Absent or Disqualified]
EventID (number)
[from lookup G and three different query's]
Table 5
EVENT
EventID [Primary key Autonumber]
Event number((number)
Distance [lookup table A]
Swim stroke [lookup table B[
Gender [lookup table C[
Age group [lookup table D]
RecordID (number)
Table 6
RECORD
RecordID [Primary key Autonumber]
EventID (number)
[lookup event - it will be the same]
Record number((number)
Record holder name (text)
Record holder surname (text)
Time (text) [formatted as 00:00,00]
Team name (text)
Team abbreviation (text)
Record year (text)
Releationships:
Table1 OrganizerID to Table2 OrganizerID
Table1 TeamID to Table3 TeamID
Table1 EventID to Table5 EventID
Table3 SwimmerID to Table4 SwimmerID
Table4 EventID to Table 5 EventID
Table 5 Event ID to Tabell RecordID
At the end of the meet the database would usually be saved and used the next
year. Sometimes the teachers want to change events and this must then be
necessary. With the start of a new event, example a club meet and not a
school meet then I want to be able to delete the records in the following
tables: Teams, Swimmer, Events, Records as to start a new meet with other
events, records, teams and swimmers, This happens quit a lot because they
organize more than one different meet each year. The points of each team are
calculated by a query from the table Points [lookup G] which contain the
following three fields: Swim meet, Placed [first second ect} and, Points
[which are allocated to each place before the meeting start]
Thanks Duane, but I told your this is a lot to read
I really appreciate your help and effort and trouble reading through this
Kind regards