If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autofill field on form with values from another table
I have a form based on a main table of geographic features. However, for all
new records, I would like to have the Geography Feature ID field autofill based on a separate table of allowable values. I would use the autonumber format for this, however, the allowable values are a list of letter codes (i.e. AAAA through to AAAZ). I already have several records with acceptable codes...however I would like all future records to pull ID's from this table. What would be the best way to go about this? Any help would be greatly appreciated. Thanks. |
#2
|
|||
|
|||
Autofill field on form with values from another table
amiliab wrote:
I have a form based on a main table of geographic features. However, for all new records, I would like to have the Geography Feature ID field autofill based on a separate table of allowable values. I would use the autonumber format for this, however, the allowable values are a list of letter codes (i.e. AAAA through to AAAZ). I already have several records with acceptable codes...however I would like all future records to pull ID's from this table. What would be the best way to go about this? Any help would be greatly appreciated. Thanks. What have you tried so far? How are your tables structured? -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|