Form for Data Entry of transactions

[Guest]

I am creating a database for a business that sells the following types of
items:

1) Tickets to sports matches;
2) Corporate Boxes to sport matches;
3) Sports jerseys.

When entering in the transactions into the database I need to know whether
it is possible that for Item (2) above to only show those boxes/suites that
have not been sold. For the other items it is not relevant as they will not
be soldout.

Any thoughts???

 

[Guest]

James,

If you have a field that identifies the seat type and another that
identifies the status, use a query to build the recordset for your form.

SeatStatus
---------------------
SeatStatusID(AutoNumber Primary Key) SeatStatus (Text)
1 Available
2 Sold
....any other possible statuses

SeatType
----------------------
SeatTypeID (AutoNumber Primary Key) SeatType (Text)
1 Balcony
2 Main Floor
3 Box

With the sample data shown above, the query would be something like:
SELECT <your fieldlist> FROM <your table>
WHERE YourTable.SeatStatus<>2 AND YourTable.SeatTypeID = 3