Either/Or Combo box?

[Guest]

In a form, I need to indicate the relationships between two people. I have
tables for types of relationships (supervisor, team leader, team member)
[TY1,2,etc], the type of relationship between two people [TK1,PK1,PK3], and a
personnel table [PK1, etc.], but unfortunately not all personnel may be
currently listed in the personnel table.

In a form, I used a combo box because I want to EITHER select the key that
already exists in the personnel table for a person OR or make a new entry,
but the entry would be in multiple columns Last Name, First Name, Company,
etc. Unfortunately, the Combo box only allows for a single entry Last Name,
and I can't figure out an alternative way of approaching this task.

Thanks for any and all ideas.

 

[Guest]

Sorry if this is an obvious question: Why can't the extra personnel be added
in the table?

 

[Mr. B]

Sorry if this is an obvious question: Why can't the extra personnel be added
in the table?

In a form, I need to indicate the relationships between two people. I have
tables for types of relationships (supervisor, team leader, team member)
[TY1,2,etc], the type of relationship between two people [TK1,PK1,PK3], and a
personnel table [PK1, etc.], but unfortunately not all personnel may be
currently listed in the personnel table.

In a form, I used a combo box because I want to EITHER select the key that
already exists in the personnel table for a person OR or make a new entry,
but the entry would be in multiple columns Last Name, First Name, Company,
etc. Unfortunately, the Combo box only allows for a single entry Last Name,
and I can't figure out an alternative way of approaching this task.

Thanks for any and all ideas.- Hide quoted text -

- Show quoted text -

Never expect, require or even allow users to add data directly to a
table. Use a form.

You would need to use the "Not In the List" event of your combo box to
add the new record. In your case, rather than just being able to add
a value typed by the user into the combo box, you would need to open
another form where the user would complete all the required info and
then when the required data has been entered, you would let the user
click a button which would save the new record to the table, close the
form and requery the combo box (which would add the new value to the
combo box) and set the new value to be the selected value of the combo
box.

If this seems overly complicated, just take it one step at a time.
Never try to eat the entire elephant in one bite! :>)

Try searching this news group for Not in List. You should find
plenty of help for adding a new value to your combo box.

The fact that you require more that a single value for your record
should not be any problem.

HTH

Mr B

 

[Guest]

Yes Scuba, Mr. B is correct as those entering data are mostly Access
illiterate, and the last thing I would choose is to give them access to the
personnel table. But thanks for your interest.

Mr. B.
That is just the type of solution I was looking for. Also I found some
interesting approaches in the search for "not it the list" in the forum.
Thanks muchly for your help, R-

 

[Mr. B]

Yes Scuba, Mr. B is correct as those entering data are mostly Access
illiterate, and the last thing I would choose is to give them access to the
personnel table. But thanks for your interest.

Mr. B.
That is just the type of solution I was looking for. Also I found some
interesting approaches in the search for "not it the list" in the forum.
Thanks muchly for your help, R-









- Show quoted text -

You are quiet welcome. Glad to help.

Mr B