C
chris
I have a database which contains names (from various parts of the
world) which are variable in spelling and the order of names used so
when searching it I use a form based an Allen Brown's model (http://
allenbrowne.com/ser-62.html) which uses wildcards to search for the
presence of character strings across several fields. The form
presents, in continuous forms layout, a list of all records containing
string. I can click on an individual record row to open another form
showing full details of the record and I have a control button on ithe
search formt to enable me to add a new record when the details I am
looking for are not found.
Names of individuals (and/or their IDs) need to be looked up from
tblPerson and filled into fields in tblProject. At present I use a
combo which also makes use of wildcard searches to fill the rowsource
with likely matches across several fields. However, this does not
easily give me the option to add new records to tblPerson if the one I
want isn't present. I would like to use my existing person search form
as a means of filling in fields in tblProject. In some places I want
to fill in just the PersonID (but display the name) and sometimes I
want to fill in the complete name too (to keep a historical record).
How can I best select the record from the search form and copy the
required details to tblProject through frmProject? If a control on
frmProject is to contain an ID but display a name does this have to be
a combo even though I don't need one? I would be glad of suggestions
on how to achieve this.
Chris
world) which are variable in spelling and the order of names used so
when searching it I use a form based an Allen Brown's model (http://
allenbrowne.com/ser-62.html) which uses wildcards to search for the
presence of character strings across several fields. The form
presents, in continuous forms layout, a list of all records containing
string. I can click on an individual record row to open another form
showing full details of the record and I have a control button on ithe
search formt to enable me to add a new record when the details I am
looking for are not found.
Names of individuals (and/or their IDs) need to be looked up from
tblPerson and filled into fields in tblProject. At present I use a
combo which also makes use of wildcard searches to fill the rowsource
with likely matches across several fields. However, this does not
easily give me the option to add new records to tblPerson if the one I
want isn't present. I would like to use my existing person search form
as a means of filling in fields in tblProject. In some places I want
to fill in just the PersonID (but display the name) and sometimes I
want to fill in the complete name too (to keep a historical record).
How can I best select the record from the search form and copy the
required details to tblProject through frmProject? If a control on
frmProject is to contain an ID but display a name does this have to be
a combo even though I don't need one? I would be glad of suggestions
on how to achieve this.
Chris