Auto Fill of Form Fields from associated Tables

[jcbhydro]

Good Morning,
I have a data entry form feeding a table named [Group Members] using Access 2010.
It has 4 fields; [Group ID] & [Group Name] derived from tbl.[Groups] and [Member ID] & [Member Name] derived from tbl.[Mail List]. The 'ID' fields are foreign keys from the respective tables.
The 2 'Name' fields have drop down lists for input selection, but my requirement is to cause auto fill of the 'ID' fields when the respective 'Names' are selected.

I have found a few references to similar problems on the Forum but none of the proposed solutions have been successful. I had assumed that this simple requirement could be achieved with a suitable control on the form property sheet. It is so simple to do in Excel!!

Any suggestions would be gratefully received.

jcbhydro

 

[spikepl]

You should not have the table Group Memebers containing copies of data - the GroupID and MemberID is enough and the form then works on a query that extracts required data.

Google and assimilate the concept of data normalization (this is the main difference from Excel). Also, see this about naming of objects: http://www.access-programmers.co.uk/forums/showthread.php?t=225837

 

[jcbhydro]

The [Group Members] table was built, on advice from this Forum, because it will eventually incorporate data other than that copied from the other 2 tables. It would be inappropriate to clutter these 2 tables with unrelated data.

Hence my need for autofill of the current fields is still relevant.

jcbhydro

 

[spikepl]

The table [Group Members] should not contain copies of data from other tables. If you had followed the remainder of the advice given in #2 you'd know that.