Search results

I have a straightforward question: do I have to manually create a junction table in Access 2007 for a M to M relationship if I'm going to have as PK, two FK which are Autonumbers from the linked tables? I can't see how Access will know "on it's own" how the junction table goes. I'm going to use...

Does anyone have some code for creating a search box in a form which uses wildcards, which allows users to enter data and then shows the information for that single record chosen? Thanks in advance

Hi, I have a form with a tabs control of 6 tabs. Each tab has a subform of 10-12 fields. These subforms depend on tables which are linked by a 1-to-1 relationship. Client ID is the shared key of all these tables. I want to have a single record selector for all the tabs, and not for each tab...

Hi, I have a form with a 6-page tab control, each page containing a subform. The subforms have between 10 to 15 fields each. The subforms were designed from tables which share a 1 to 1 relationship, all with the same key (Client ID). I want to link these subforms, so that Access recognizes that...