Search results

I understand the M-N relationship between the clients table and services but what I don't know is how to physically create the junction table in the Relationship window. Is creating the two tables Clients and services enough, or do you have to physically create the junction table: how do I...

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

Thanks Simon. I have done so and it works fine.

Simon, I don't where the tabs fit in. I know how to insert a subform within a form, but what the tabs? Could you explain further or give some more guidelines

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...