Form input

[Stephanie]

Hi. This is driving me crazy...

I have a subform on a main form. I want some data to default using combo
boxes and some data to be specific to the individual. Premise: Contacts
volunteer with their Animal for on-going Volunteer opportunities. An
on-going opportunity (e.g. Shriner's Hospital) could have started in 1999,
but the Contact/Animal team started in 2004. I have combo boxes on the
VolunteerName. I want to keep track of when a Contact/Animal team started
and ended so that I always know who volunteered there in the past and who is
currently volunteering there now (that's the Contact specific info I want to
write). But I can't seem to write this Contact/Aninmal specific data along
with the default data. The main form is based on Contact and the subform is
as below.

Animals
AnimalsID

Volunteering
VolunteeringID
VolunteerName
VolunteerOngoing

Event
EventVolunteerID
ContactID
VolunteeringID
AnimalsID

SELECT Event.*, VolunteerOngoing, Volunteering.VolunteerName
FROM (Event LEFT JOIN Animals ON Event.AnimalsID = Animals.AnimalsID) INNER
JOIN Volunteering ON Event.VolunteeringID = Volunteering.VolunteeringID
WHERE (((Volunteering.VolunteerOngoing)=Yes));

I've tried to add a table for specific Contact-Volunteer Detail info. I've
tried to modify existing tables to add the detail info... Can it be done?
I'd appreciate any suggestions. This is the big showstopper in my database
design.

 

[Anand.V.V.N]

Hi Stephanie,

Contact Specific information in the sense where the person/animal volunteer?
i.e. the orgination. Or are the details about the person/animal that
volunteer? Can I just Clarify about what you want to store about the contact
specific details.

Any way from what I assume you can have a contact table where you would
store the contact specific details like name,address and related it to other
tables using the contactid.

P.S. is ContactID from the contact specific information by the way?


Any way its good to store the contact specific infromation spertaely and use
the ID to related to the other tabels.

Hope what I posted didn't confuse you more.

Anand

 

[Anand.V.V.N]

Hello Stephanie,

I am scared to ask but, I would like to clarify one thing and I am not sure
how to put it in words.

Anand

 

[Stephanie]

I do have a Contact table (ContactID as key) that contains name, address...
What I'm looking for is to assign the Contact to an on-going volunteer
opportunity. That's the easy part, I have the VolunteerName combo box (e.g.
Shriner's hospital).

But I want the "contact specific" info linked as well: Susie volunteered at
Shriner's from 1/2/03 to 1/3/05. Even though Shriner's program started
1/1/01 and is still going strong. I know I don't want "contact/volunteer
opp" data in the Contacts table. But I don't know where to put it or how to
get the form to work.

The subform is linked to the mainform via ContactID. The subform allows me
to chose "Shriner's" for Susie. But then I'm not able to input info specific
to Susie regarding her volunteer dates in the subform. The subform won't
allow me to write new data, just use combo boxes to select pre-entered data.
So that's the question- how can I write data to the subform?

 

[Anand.V.V.N]

Hi Stephanie,

In the sub-from combox you can add a entry called "New" or something so when
the user selects that itme you can write code to update or add the content
you want.

How comfortable are you with coding?

Anand