HELP: Starting a cascading combo with no records!

[Guest]

The purpose of this is that

In a form I have two bound combo boxes: Combo 1 is for customer name and
Combo 2 is for first line of address.

Combo 1 source: tble_customer
Combo 2 source: tble_branch

Each customer can have many branches

I have inserted VBA into the "not in list" event in the form to add customer
names to "tble_customer" which works fine.

I created an append query that would append combo 1 and combo 2 to
"tble_branch" but I get a key violation. How can I otherwise make sure the
address I type goes with the correct customer name.

 

[Guest]

I've just realised my append query wants to append all rows. I only want to
append the current record. Can some kind of filter be applied based on the
current record?

 

[Guest]

I have had a go and, as is usually the case, I think I've worked it out.