Display lots for 1 seller

[daveswaves]

I know this should be simple, but I'm a complete beginner.

The Sellers layout (form view) displays a record from the Sellers table (3 fields: SellerID, Address, AuctionDate).

The form has a button linked to a script that takes me to the Lots layout (table view). The Lots layout displays the Lots table (4 fields: SellerID, Price, LotNo, LotName).

The problem I'm having is this. I only want the lots of the current seller to be displayed - if the current SellerID equals 46 (Sellers layout) I only want the lots with same SellerID to be displayed on the Lots layout.

What code do I need to use in my script to achieve this?

Thank you for any help.

daveswaves.

[aldipalo]

Not sure about 7. In Ver 8+ you would use "Go To related Record." If you have this command in your script language that should do it.

Of course you have set a relationship between Seller table and Lots table using Seller::sellerID=Lots::sellerID?

HTH

[daveswaves]

This is exactly what I needed.

Thank you.

daveswaves.