Am Dienstag, den 12.02.2008, 09:07 -0500 schrieb Andrew Jensen: > You really have to choices on how to address this. > > 1 ) use the built in data navigation control and use your macros to catch > the events on the dataform controls and work with the other tables data, via > the other dataform control, appropriately. > > 2 ) do not use the built in data navigation bars at all - rather use a groug > of your own buttons and some macro code to pre emptively move the record > pointers ( using the dataform controls ) and handling posting data to the > tables ( using the dataform controls, or separate prepared statements > perhaps )
3) Put the two tables into one. Having a strict 1:1 relation is some sort of denormalization (or over-normalization? dunno which normal form), if each of the tables has to have one record for each key, the data actually belongs into one single table. With "strict 1:1" I want to describe the records are pairs AND there is no third record in one of the tables pointing to one record already bound in a pair. HTH, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
