Is this possible?

[miss031]

I am just getting lost here...

I have contacts, whose attributes (names, addresses, etc.) are stored in
various other tables, and each contact is assigned a bidder number. Now,
this is not a unique identifier - some bidders are assigned a number for one
sale, and a different number for the next sale, and some are assigned a
number permanently. The numbers that are only assigned temporarily are
re-used in the future. Hopefully this gives you an idea of my table
structure:

table__contacts tbl_cont_bidder
-contact_ID(PK) - - - -> -contact_ID
-email_address -cont_bidder_ID (PK) tbl_lkp_bidder_number
-bidder_ID - - - - - - - - >
-bidder_number_ID
tbl_sale_information -is_perm (chk box) -bidder_number
-sale_ID (PK) < - - - - - -sale_ID
-date_ID
-sale_current (chk box)

When users are working with records, they are all filtered by the True value
of "sale_current" in the "tbl_sale_information". I need to form a query that
shows the bidder's number at all times if it is permanent, and only show the
temporary bidder numbers if they are for the sale that is current. Clear as
mud, right?

 

[miss031]

Sorry, word wrapping got me. Try this:

table__contacts tbl_cont_bidder
-contact_ID(PK) - - - -> -contact_ID
-email_address -cont_bidder_ID (PK) tbl_lkp_bidder_number
-bidder_ID - - - - - - - >
-bidder_number_ID
tbl_sale_information -is_perm (chk box) -bidder_number
-sale_ID (PK) < - - - - - -sale_ID
-date_ID
-sale_current (chk box)

 

[miss031]

This is making me mad!

table__contacts tbl_cont_bidder
-contact_ID(PK) - - - > -contact_ID
-email_address -cont_bidder_ID (PK) tbl_lkp_bid_number
-bidder_ID - - - - - - > -bidder_number_ID
tbl_sale_information -is_perm (chk box) -bidder_number
-sale_ID (PK) < - - - - -sale_ID
-date_ID
-sale_current (chk box)