combining customers in a form or ??

[diverman]

My brain is melting :-(

From a "Customer Table1" on a "Date/Time" I want to create a record list showing "ID", "Name", "Town" on the left hand side.
This list would be stationary.

On the right hand side from a"Customer Table2" on a "Date/Time", I want to create a record list showing "ID", "Name", "Town" .

Next to each record I want a tickbox.
This will allow me to tick one record from the left hand list, look down the right hand list and tick up to two records that match.

After selection(s) are made I want a "Combine" button that causes the right hand selections to move up and position themselves next to the left hand selection.

If two records are selected on the right then a blank would need to be inserted under the left record.

Am I asking the impossible?????

TIA, Gordon.

[NeoPa]

Won't be back on till Thursday, so here's a quick outline.
Add 2 Foreign Keys to tblCust1 (table) that point to tblCust2 (2nd table).
Have form with 3 ComboBoxes and a command button.
1st combo cmbCust1 lists tblCust1.
2nd & third cmbCust2a & cmbCust2b list tblCust2.
Select records from first two combos and, optionally, third too.
On click of command button update tblCust1 rec with FKey(s).
Display results on report, laid out as required.
It is possible to adjust height of detail line on the fly to adjust depending on whether 2 or only 1 FKey has been entered.