If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form for Data Entry of transactions
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??? |
#2
|
|||
|
|||
Form for Data Entry of transactions
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.SeatStatus2 AND YourTable.SeatTypeID = 3 "James T" wrote: 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??? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
FOrm and COmbo Box... | NWO | Using Forms | 17 | November 20th, 2005 05:47 AM |
Form won't allow data entry | jwrnana | Using Forms | 11 | October 3rd, 2005 01:45 PM |
Tell if Form is a Dialog | Alex | Using Forms | 7 | August 30th, 2005 06:22 PM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |