G
GaryS
I have two tables, tA and tB.
tB just has two fields, B.id (autonumber) and B.name
tA contains a field with Bid in it. A.Bid may or may not
contain a value.
I am designing a frmA to update/add to tA.
Is there an easy way on frmA I can place a control that:
1. displays B.name if I'm updating an existing record in
tA
2. if I'm adding a record to tA, allows me to type in the
B.name for the new tA record, and, if that B.name already
exists, use its B.id as the value for A.Bid; if it doesn't
exist, it will add a new record to tB with B.name = to
what I typed in and set A.Bid to the new B.id.
Wow! I didn't think it would take that many words to
describe what must be a common situation.
GaryS
tB just has two fields, B.id (autonumber) and B.name
tA contains a field with Bid in it. A.Bid may or may not
contain a value.
I am designing a frmA to update/add to tA.
Is there an easy way on frmA I can place a control that:
1. displays B.name if I'm updating an existing record in
tA
2. if I'm adding a record to tA, allows me to type in the
B.name for the new tA record, and, if that B.name already
exists, use its B.id as the value for A.Bid; if it doesn't
exist, it will add a new record to tB with B.name = to
what I typed in and set A.Bid to the new B.id.
Wow! I didn't think it would take that many words to
describe what must be a common situation.
GaryS