Auto fill

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Basically I have fields for first, middle, Surname and House fields in both tables and I want it to have it so that when an ID in one table is entered it looks up the other values within the same record as the ID and then fills them into the original table. I do not mind if this could be achieved via way of a form and especially combo boxes. Oreferably the user would select an ID from a combo box and the other fields could be entered automatically.

Could anyone with any ideas please respond to my e-mail address:

(e-mail address removed)

Thank you for any support

Infidellic
 
Two problems with your question. It sounds like you are working with a
very poor database design. Not knowing why you would want to do what sounds
like it should be done with linked tables, I can't really make much of a
suggestion.

Next you also don't seem to understand (yet) how newsgroups work.
Expecting an answer by e-mail may sound logical, but it is not a good idea.
Newsgroups work in a very dynamic way. You ask a question, someone suggest
and answer, that answer prompts someone else to go further or another
direction and often after several people have joined in and each listening
to what the others are suggesting figure out the right answer.

I understand that for various reasons sometimes it is not possible to
return to the newsgroup, but you should know what many people will not
bother replying email and it is also consider poor manors to request a email
reply.

I am sending this both to the newsgroup and via email in the hope that
you will return to the newsgroup and that you either have a unique problem
or just did not understand how newsgroups work.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Infidellic said:
Basically I have fields for first, middle, Surname and House fields in
Click to expand...
both tables and I want it to have it so that when an ID in one table is
entered it looks up the other values within the same record as the ID and
then fills them into the original table. I do not mind if this could be
achieved via way of a form and especially combo boxes. Oreferably the user
would select an ID from a combo box and the other fields could be entered
automatically.
 
I have two questions.

First it seems you are trying to use a very poor design database. What
you seem to be describing would be best addressed by using two related
tables. Is there some reason are doing it this way?

Is there some reason you can't return to the newsgroup to read the
responses. It is generally considered not very considerate to ask for an
answer and not be willing to return to get the answer.

Newsgroups are dynamic. One answer leads to another etc. In the end we
get far better answers by working off each other's ideas. That can't happen
if we just reply to you.

I am sending this response to the Newsgroup and the email address and
hope you will return to the newsgroup.

--
Joseph E. Meehan

26 + 6 = 1 It's Irish Math


Infidellic said:
Basically I have fields for first, middle, Surname and House fields in
Click to expand...
both tables and I want it to have it so that when an ID in one table is
entered it looks up the other values within the same record as the ID and
then fills them into the original table. I do not mind if this could be
achieved via way of a form and especially combo boxes. Oreferably the user
would select an ID from a combo box and the other fields could be entered
automatically.
 
Back
Top