|
A
|
Abul 5/27/2014 |
|
Hi there, I'm hoping someone way more experienced than myself can assist or point in the right direction. I have 2 tables one members with ID, first name, surname etc and the other table Regiment with Officer 1 and name, Officer 2 etc. What I want to do is to be able to insert the ID into Officer 1 of the Regiment table and then have the database pull through the surname which that ID relates to in the name field. Is this possible and if so how can it be done? Many thanks in advance for your reading and time given. J
|
|
|
J
|
jasongreenwood author 6/2/2014 |
|
Abul brilliant thank you very much. Step 1: Create custom view table from "Members". Step 2: Use Lookup wizard option for the "Member or Officer" field on the Editor View of Regiment form. Select reference link from custom view Members table. Step 3: Click on "Auto Fill" button of Lookup wizard then select your necessary fields from that custom view Members table. That's it. |
|