Linked Fields

[steve c matco]

I have a database that manages hot ait balloon flights.

I have a pilots table, a passengers table, and a flights
table to tie the info together.

I had the system all set up and needed to add a notes
field to my PILOTS table to track the capacity of each
pilot's equipment. I want to store this data in the
pilots table, then have it show up with the pilot name in
my flights subform. I tried to set up a relationship but
the data won't show up on the flights subform. Any ideas
as to why this isn't working? Possibly the fact that i
added the other relationship after the first had always
been established?

Thanks!

 

[Tim Ferguson]

I have a pilots table, a passengers table, and a flights
table to tie the info together.

Something like this then:

PILOTS FLIGHTS
====== ======= PASSENGERS
*LicenseNumber ---< *Pilot ==========
FullName *Passenger >---- *PssgrNumber
NextOfKin FullName
Equipment HomeTown


But I don't think it's really right. Surely there should be a flights table
and a tickets table, otherwise you'll restrict each passenger only ever to
be able to fly with each pilot once:-

FLIGHTS TICKETS
PILOTS ======= ======= PASSENGERS
====== *FlugNummer -----< *Flight ==========
*LicenseNumber -< Pilot *Passenger >-- *CustomerCode
FullName DateOfFlight Price FullName
NextOfKin StartLocation InvoiceNo HomeTown
Equipment LandingConditions

I had the system all set up and needed to add a notes
field to my PILOTS table to track the capacity of each
pilot's equipment. I want to store this data in the
pilots table, then have it show up with the pilot name in
my flights subform.
I tried to set up a relationship but
the data won't show up on the flights subform.

Is the subform or the mainform connected to a Pilots table? If the field is
in the table, then you don't need any futher relationships, just a textbox
control in the appropriate place.

HTH


Tim F