Advice Sought

[Wizzweb]

Hi all

After information to add a feature to a simple address book type DB in Access 2K

The feature required is a form of questionaire to be added to an existing Addressbook. The user will be required to enter any number of skills from a list, up to 20, and these may be read, along with the existing data, when a search is run.

As I haven't done any Access work for a couple of years, I seem to have forgotten and apologise if there is a simple solution to my problem and thank you for your assistance.

Ken

 

[wizcow]

Ken

Sounds like you will want to add a table with your questionare info, plus the user ID.
Then relate the user ID to the Address book table.

HTH
Tom

 

[Wizzweb]

Hi Tom

I sorted the problem out by creating a tblSkills and each subject as a field. All is working OK at the moment, but I have another question which I will open as a new thread.

Ken

 

[Pat Hartman]

Since there is a many-to-many relationship between people and skills, you actually needed to add two tables. A skill table which just contains the list of skills you are tracking and a personSkill table which relates people to their skills. The PersonSkill table has a row for each skill that a person has so if a person has 3 skills, there will be three rows for that person in this table. If another person has 4 skills, there will be for rows for that person in this table.

 

[Wizzweb]

Hi Pat

Thanks for your contribution. As I mentioned in my last posting, I have got it working by a similar method to the one you mentioned.

I have a subform for the skills on the main form, which has all the other details.

I am now trying to work out how to make a search facility on the form, without using the buttons on the toolbar.

HTML and Java was never like this.

Ken