Search results

Thank you. I'm still not having any luck, as it is telling me I have ambiguous joins OR it will only bring up the names and IDs of the Staff and not of the Individuals. I am willing to bet that the issue is that both tables are joined on the profile ID, but I'm afraid I've overthought all...

Hi! I know I'm simply not having any luck writing the SQL statement to produce the results I'm looking for and I was hoping you could help! I have a query in which I am pulling up IndividualID, IndividualName, StaffID (which is actually the Individual ID, but is a foreign key in a separate...

Alright! Hopefully this will work!

Grr. I'm trying to change my "multivalued fields" so I can save it in an mdb file.

Curtis: Yes, they are correctly linked. However it seems that perhaps the problem is that the Application ID should be on the main form to act as a second master field. Does that sound right? (As I will always be using this form for application data entry, I don't foresee any issues with...

Whoops! I'm sorry, my mistake.

Hello, all. I'm still struggling with a form I've been working on for a week. I'm not sure what the problem is, exactly, or whether I can even do what it is I'm trying to do. To save everyone's sanity, I've attached the zipped database. In the end, what I would like is to be able to tab...

Scooterbug - Thanks! I do have my tables set up in more or less that way. (I have a lot of tables and for brevity I was just mentioning a few.) MissSingLinq - Rats. I thought that might be the case. So it IS generating multiple IndividualIDs, in all likelihood? And if I just re-order...

Hello! I've been working on creating a new database and really want to create a simple, tab-through data entry page for entering applicants for each of our programs. I'm having some trouble, however. I currently have it set up in the following way: frmIndividuals comprises the main form...

Ack! Thank you. I can't believe I missed that! Thanks so much!

Sure, here it is: http://picasaweb.google.com/lh/photo/tyDaF8k72FA3Gf251mmvLQ?authkey=Gv1sRgCP_4hfOmy4TGvAE&feat=directlink I'll look for the way to post the database. (Though I admit it's probably the least effective way to organize data.)

Link Master Fields: IndID (on tblIndividuals) Link Child Fields: Individuals (which is IndID)

I have a subform on a main form that details the following: - School Type (Elementary, High School, University) - School Name - Year in School (Freshman, Sophomore, Junior, Senior) - Year (Year that the student was a Freshman, Sophomore, Junior, Senior) I changed School Type and Year in School...

I know that answers about this are posted all over the internet, but for whatever reason, after hours and hours of fruitless attempts, I'm simply unable to apply what's on the internet to my specific case. :( I appreciate any help you can provide! What I want is two cascading combo boxes...