Bidirectional links between tables

Hi All,

I misread a question earlier, and built the answer to that, But I think the answer is something that might be useful in any case.

The answer is a method to enter bi-directional links between two tables. In the example below, I have a Invoice header and a detail table. In the detail table the Invoice Number is a lookup from the Header table. In the header table I have a list of all the details line items for the invoice.

Enjoy
Rambling Pete

2 Likes