Simple problem I cannot figure out. HELP!!!

[lneel]

Ok,

I have attached an example db. I have 2 tables. I have 1 form.

My issue should be SIMPLE to resolve. I have name and membership information in one table and need to use it multiple times in another table. I want to be able to select a name from a combo box in a form and have that selection populate the name and membership data.

Tables:
Shooters-Has 3 columns- ID, Name and IDPANum
MD-Has 10 columns, only 2 relevant to my issue, Name and IDPANum

Form:
MD-from this form I want to be able to select a name and have that selection populate the name and IDPANum fields in the form.

This is such an easy thing but I cannot get it to work. Please help.

 

[jeremie_ingram]

Ok, if this will work for you.....

What I did is remove the duplicate fields from the second table and create a lookup filed to the shooters table. then I changed the form by deleting the previous fields and replacing it with the new on I created.

Let me know if this works for you or if I am way off base.

 

[Mile-O]

You have a repeating group in your MD table and this means you need a further table to normalise your data. Since the fields aren't well named - just acronyms - I can't suggest much more on the normalisation process (which is your real problem here) and you should not name fields Name as it is a reserved word within Access.

 

[trucktime]

Problem

Check out the link below, a very useful sample mdb by Pat Hartman that demonstrates the technique you want to use.

Also, in your tables you should not use the fieldname 'name', it is a reserved word in Access and it may cause you problems at some point. Better is to use something like 'membername'. And it would also be a good idea to rename 'ID' to something like 'MemberID'. In case you ad more tables it is easier to identify wich table the ID is coming from.

http://www.access-programmers.co.uk/forums/showthread.php?t=68985

Good Luck and Merry Christmas

 

[lneel]

Ok, if this will work for you.....

What I did is remove the duplicate fields from the second table and create a lookup filed to the shooters table. then I changed the form by deleting the previous fields and replacing it with the new on I created.

Let me know if this works for you or if I am way off base.

Jeremie,

Almost perfect. The only thing is I need the IDPANum to be in a seperate field from the Name. I have read the others posts and will correct the resevered word issues. Thanks for all your help.

Lee