Search results

Got It Thats a bit clearer. I'm no pro at this, but I think I've got your answer. Short story is as posted by others earlier in the thread....You don't need another table because your relationship of owners to shops is 1 to 1. You also DO NOT need additional tables to use different forms to...

This thread is like a chinese finger trap....lol I'm trying to understand the relationship between merchants, shops, and customers, and I think it is still a pile of spaghetti. Phil, I'm trying to understand your terms, but it's no luck. I think you may need to relabel things. In your post...

Thanks Gem. I actually did a little homework on the site and ran a search on the notinlist theme and got a big education, but I like your idea best. I'll give it a run, thanks.

Any Updates on Updates? I'm in a similar boat. Any inputs on how to force a requery in an open form when a subform or something is closed. I got into macros, and couldn't find anything appropriate. I have a similar routine to add a new person to a list by opening a form with the NotOnList...

Yes....my typo...."junction table" above...."intermediate table" is ambiguous....any help on the substance of the Q?

Phil, I think the point of confusion is the structure of your data. The form function should be pretty straightforward after that is squared away. If you have a Merchant-to-Customer relationship, as it seems, it would be very odd if that was a one-to-one. Usually one merchant could have...

Maybe I didn't describe it right...I'm quite sure they are many-to-many. It's the "classic" books and authors example. One Author can write multiple books, and every once in a while a book can have multiple authors...necessitating a many-to-many with an intermediate table. I've got that...

Hey all. First post....cool site Got into an Access project that requires multiple many-to-many relationships and I'm curious if the way I'm setting it up makes sense. The project covers research projects which have multiple authors and multiple areas of impact. I've got the Many-to-Many...