A
Allison
I know this is probably very simple for most people but I
am new to this!
I have the following tables:
Subscribers: SubscriberID, SubscriberName
Participants: ParticipantID, ParticipantName,
SubscriberName (relationship with Subscribers table using
SubscriberID)
Time Logging: ParticipantName(based on ID), SubscriberName
(based on ????)
As "One Subscriber" can have "Many Participants", I want
the Time Logging table/form I have created to be able to
auto-select its appropriate Subscriber as soon as I enter
the Participant.
I have tried the SELECT FROM WHERE .AfterUpdate
Expressions but I am missing something as I end up with a
blank drop-down box at best!
Can someone please confirm/explain to me (in very simple
terms/step-by-step) which relationships I need and what I
need to type where? It's driving me mad as i don't know
enough about SQL, etc to make it work!
Many thanks in advance.
am new to this!
I have the following tables:
Subscribers: SubscriberID, SubscriberName
Participants: ParticipantID, ParticipantName,
SubscriberName (relationship with Subscribers table using
SubscriberID)
Time Logging: ParticipantName(based on ID), SubscriberName
(based on ????)
As "One Subscriber" can have "Many Participants", I want
the Time Logging table/form I have created to be able to
auto-select its appropriate Subscriber as soon as I enter
the Participant.
I have tried the SELECT FROM WHERE .AfterUpdate
Expressions but I am missing something as I end up with a
blank drop-down box at best!
Can someone please confirm/explain to me (in very simple
terms/step-by-step) which relationships I need and what I
need to type where? It's driving me mad as i don't know
enough about SQL, etc to make it work!
Many thanks in advance.