Forms 5: Populating Intersection Tables

How can I create rows for my intersection table before committing to the database.

I have two tables in my form, Table1 and Table2. As I add Items in Table1 and Table2 I want to create an intersection between [Quoted] rows in Table1 and Table2 . The idea I had was to capture a double click on [Quoted] Table1 and create a row in my intersection table(Table 3) between Table1.(clicked row) and the current row in Table2. The problem is, if any of the rows have not been committed to the database I [Quoted] have no key to write into my intersection table.

In general, I'm trying to populate an intersection table with foreign keys before the keys are available.

I'm looking for ideas as to how other developers have handle this situation.

[Quoted] Thanks for any help, Brian Received on Sat Mar 11 2000 - 01:02:57 CET