Search results

See if this link helps you: Eep! Many to Many Relationships If it doesn't, post back and maybe I (or someone else) can be of more help. --Sara

And Lo, there was singing And the Sara did grin. Because she had figured it out. Ahh. Woo-Hoo. Let me see if I can explain this, in case someone else has this confusion... The queries are set up basically as I said. I made both forms separately. In the subform portion, I made a...

Thanks for all the help! Just one more question (for now...) Do I use a subform to populate my junction table? I've been looking at Pat's example to help me try to figure it out, but it's starting to confuse me. (Probably because I've been looking at it for too long.) This is what I'm...

All right, then I think that my situation is a little bit different because one application can be used for many postings, and one posting can receive many applications. BUT one application will not apply to the same posting more than once. So can my junction table have just the primary keys...

I have downloaded Pat's sample, which makes everything much clearer... But as far as the joining table goes, I'm still a little confused. She has three fields in her joining table, and each of them is a primary key. I can understand using the joining table, and using the other primary keys...

Cosmos, You said to me: Yes, that is correct. Well, basically... Applicant is a different table, with a one to many relationship with tblApplications. Application1 can apply to Position1, Position2, Position3. Position 1 can receive Application1, Application2, Application3. The...

Thanks! I don't know why I didn't see these things when I did a search... I must have entered my criteria badly or something... :rolleyes: --Sara

Hi! I'm working on a database that tracks postings for vacant positions, and applications to those positions. There are four main tables, plus a few lookup tables so far. tblPositions PositionNo (PK) CostCenter (Office the position is in) ClassCode (Title of Position) VacancyDate (Date...

Thanks, RichM! It was the second one. I didn't even think of that, but as soon as I read it I felt like a dummy. :rolleyes: Now I can start being productive. --Sara

Okay, I re-worked the whole query, but it wouldn't let me do a left join, saying I had an ambiguous outer join. so I left it as an inner join, and that works fine. I assigned the combo box to tblPositions. I'm still getting this error: (Runtime Error 3022) "The changes you requested to the...

I have the combo box based on a separate query - could that be what is causing me trouble? Problem is, if I use the query I am using for the form, then I have positions without employees. I want these to be an option in the combo box, but the query I'm using for the form doesn't show...

RichM, Thanks for your prompt reply! Since I'm only a few minutes from leaving, I'll just address the important stuff, and leave the rest until Monday: On-Topic: How would I write the code for the requery? Off-Topic: I've just graduated college with a theatre degree. I plan to save money...

RichM, I'm a little confused. I have a tblPositions, with PositionNo as a primary key. I have a tblEmployees, which has an ID number (TDNo) as its primary key and has a PositionNo field that links to tblPositions, as you said. When I created the query for my combo box, though, I had to leave...

Thanks, Rich! That's beautiful! :D --Sara

Hi! Another question from the resident idiot. ;) I'm working with a form that I'm using to edit employee data. It is built from a query which uses the following fields: TD# (primary key, employee ID number) Last (last name of employee) First (first name) PositionNo (Unique number...

Try it in the report footer.

Hi! I had this problem a while ago, and it turned out I was putting the calculation in the wrong spot. Are you putting it in the report footer or the page footer? I don't think it'll work in the page footer, but it should work in the report footer. Hopefully that's helpful. --Sara

Thanks, everyone, it finally works! Aaaahhhhh.

WOOHOO!!! I am so excited! Thanks to you, Cosmos, and the people who helped me on the other post, I finally got the stupid thing to work! I've been ready to kill myself over this for about a week now, and no it finally works! Thanks so much! I love this forum! --Sara

That's what I did to begin with, and then re-did, basically. I think it was just a problem with the initial data-entry. Thanks, anyway. :D