Search results

Hmm, after a whole bunch of messing around, I changed the code to FROM tblCompanyPersonID LEFT JOIN tblAlternates, instead. However, now the "alternate" and "director" fields are blank on all of the other records (the first one is still perfectly fine). EDIT Err, nevermind, I just added an OR...

@Mihail , yeah, I actually knew what normalisation was, but I guess I just didn't bother until now, when I figured out that it could mess stuff up. I just changed all of the names to normal, however, and nothing's changed. @JHB , It only returns 1 record, strangely enough. I tried tinkering with...

SELECT [Company-personID].*, Alternates.Director, Alternates.Alternate FROM Alternates LEFT JOIN [Company-personID] ON [Company-personID].[Company-personID] = Alternates.Director ORDER BY Alternates.Director;

I didn't have this problem when I had used subforms, but there were little bits of thins I had to polish. There are basically 2 tables, and the form is based on the table PKing. It shows the PK and a few irrelevant fields. However, when the recordsource now inner joins the two tables based on...

Ehehe, I just realised. How would you recommend me to put it in? It's the PK to the field "Companyno" in "Company-personID", by the way.

Right now, I have a a form that shows all of the information about a company, all based on 1 table. I also have a query where it shows all of the people related to a company, based on a tertiary table that shows each relationship. However, I need to enter the PK of the company every time I run...

That worked perfectly, thanks. Heh, I haven't been on Access for waay too long.

Errr, never mind. I solved it by making a totally new form with the fields already included and a bunch of SQL I just messed around with until it worked. If anyone finds a way to show the names, though, that would still be appreciated. Heh.

I'll illustrate my problem with pictures. Basically, within a company, a director can have an alternate. I have done this by linking the relationship between a person and a company (company-personID) with the table "alternates". In a subform for the information about the company itself...

I don't think I'm making myself very clear here. Sorry. It needs to update 2 others. It's a bound form, but my problem's not that the data isn't getting across. The SQL isn't actually quite necessary, but I'm comfortable using it. What I'm trying to do is very petty, so that might be why you...

Ah, never mind the pre-edit post, I just got what you meant. I don't really need that for what I'm doing. Basically, I want it to copypaste things from RegAddress to PrevRegAddress1, and so on, whenever I update RegAddress. It's really just for convenience. The place I work at doesn't have to...

I'll first apologise for the ridiculous title. Anyway, my goal is to use the SQL "Update" function to set the address of a company to the previous addresses when I update something. FOr example, the fields show as Current=A Previous=B Previous 2=C When I input something to...

Errr, never mind, guys. This is embarrassing, but I accidentally added a fullstop to all of the control sources out of habit. No problems here!

Nope, the control sources all use the correct names. And they don't all refer to the "Companies" table. As I said, there is one subform and one one-to-one relationship, and those are my prblems. Although I may simply not have understood that answer. (Sorry! I haven't used Access in months!)...

I used to have a problem where my form would only show 1 record of 7. After changing the record source to a table, however, it no longer shows a particular subform, instead turning up blank. Furthermore, a one-to-one relationship between this table (company) and another(company_address) shows up...

Very suddenly today, when I'd done seemingly nothing, all of the records from my form that I'd built from a blank form disappeared, with the exception of the first record. When I try to just close everything down, nothing changes. When I put in a new record to the form, however, it's saved in...

Alright, that seemed to have worked. THanks!

Right now, I have 4 related tables. There's a table with companies, one with people involved with companies, a table linking the two by having foreign keys of the company number and people names, and a table that indicates directors and their alternates. Since there's a one-to-many relationship...

Errrrm, you know that other post you're helping me with, about dlookups? And how CJ recommended using subforms? It turns out that was the absolute solution to all of these problems. 5 hours of work in codebuilder, all outdone by a simple macro :banghead:

Ehehhehehehehehehehehhehehehhe, it turns out that the subform solved pretty much the entire thing I was working on for about a week.