I want to show a listing of the records entered in my customer database at the bottom of the screen. Any suggestions on what I "should" do?

Hi Kevin,

What you should do depends a lot on *why* you want to do this - and also on what else you already have on the layout (or will have).

There are several options. However one of them would be to create a cartesian product (X) relationship to the customer table and then place a portal based on the resulting customer TO, into the 'Footer' area of your layout. :wink2:

Hi Kevin,

What you should do depends a lot on *why* you want to do this - and also on what else you already have on the layout (or will have).

There are several options. However one of them would be to create a cartesian product (X) relationship to the customer table and then place a portal based on the resulting customer TO, into the 'Footer' area of your layout.

Thanks ray, I believe that is exactly what I want. As the user puts in customers, they will show up in a list on the same form at the footer. But what is a "cartesian product"? I am having one of those blonde moments....wait a min, I am bald...

Cartesian is an relationship operator (like the default "=", there's also <>, etc.). It's down at the very bottom of the drop-down, it's the big X. It means basically anything matches anything; so it matches all records of the target table.

Ah, got it...thanks. LOL..brain dead at times :