one to many problem

[Jenna]

I have Group of 3 tables Schedual, Maintence and MainEvents. For each day
there are 2(day and night) records in schedual and for each one of thse there
can be many records for Maintence and Mainevents. I need to generate a report
from these tables for day and then all the records that match in maintence
and mainevents. I know that i should use a one to many realition ship to do
this but i not sure how to structure it so that the queries return the
correct information. Any help would be great thanks

 

[Jason Lepack]

What are the fields that are in these tables and what are the
datatypes?

Cheers,
Jason Lepack

 

[Jenna]

Schedual contains
ordernumber = number
size = number
nextorder = number
qualityissues = memo
personal = memo
MainEvents contains
Area = number
Description = memo
Maintenance contains
Area = number
WONumber = number
Equipment = text
Description = Memo

I know that i am going to need to add a column to mainevents and Maintenance
so that they can be properally linked. I want the linking to occur
automatically so they do not have to enter the date for each one. All of
these tables are updated on the same form (mainevents and maintence are
subforms)

 

[Jenna]

I forgot to add that the schedual has a ID that is an autonumber as well as
Day = date/time