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
|
|||
|
|||
building a complicated (to me) string
Using Access 2007
I am trying to build a couple of strings from the following tables/fields. Is it possible to do with this table structure, or would it be better to add a couple of fields to the tblFamily like FamTitle (Mr. & Mrs.) and FamFirstName (John and Jane). This would seem to me to be redundant data though. Your help and guidance is very much appreciated. Kathy R. tblFamily FamID (primary key) FamLastName tblIndividual IndID (primary key) InFamID (foreign key) InTitleID (foreign key) FirstName ContactStatus (primary contact, secondary contact, child, other) tlkpTitle TitleID (primary key) Title (Mr., Mrs., Ms., Dr., etc.) The strings I would like to build: For each tblIndividual.InFamID [Title of primary contact] & “ “ & [Title of secondary contact if present] & “ “ & [FirstName of primary contact] & “ “ & [FamLastName] Example with data: Mr. and Mrs. John Doe (if there is a primary and secondary contact) Mr. Bob Jones (if there is only a primary contact) AND by FirstName instead of Title: [FirstName of primary contact] & “ “ & [FirstName of secondary contact if present] & “ “ & [FamLastName] Example with data: John and Jane Doe (if there is a primary and secondary contact) Bob Jones (if there is only a primary contact) |
Thread Tools | |
Display Modes | |
|
|