Hi,
I have a data entry form which queries two tables(Client & placement)
Client data is entered, once OK button is pressed.
Creates the Client Record and a Placement record with a Placement flag
of "A"
I want to create a second placement record if a field on the form
(NonResPlacement) is not null, where a field(NonResFlag) on placement
table = a code.
Example
Jim Smith gets info added.
User chooses 231 on field NonResCode on form.
when added user gets a client record,
a first placement record with ResCode = "R"
and a second placement record with ResCode of "N", plus some other info.
If NonResCode is Null then only one placement record with ResCode "R"
Thanks In Advance
Joe
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
