By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,553 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Help to update in Access 2007

P: 1
I have 2 tables Seat Status and Ticket. In Seat Status the default is all the seats are "Available". However in Ticket only those tickets which are booked are stored. So when the status is updated in the Ticket table, I need it to be updated in the SeatStatus table too. This should occur immediately after the update ie in the "After update" event. This should be done only for the specific ticket which is being updated in the Ticket Table. I guess i should use a macro. i tried the Setvalue action but just cant get it together. Any help?

Thanks
Nov 29 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Hey Wrath,

Welcome to Bytes,

Can you post the table structure between the two table. Since you didn't provide any details as to the table structure, it's kind of hard to guess the answer.

Expand|Select|Wrap|Line Numbers
  1. TableName:  NameHere
  2. ------------------------------------------------
  3. Field Name             Type             Comments
  4. ------------------------------------------------
  5. ID                   AutoNumber        Primary Key
  6. FirstName            Text(50)          FirstName of customer
  7.  
  8. and so on
  9.  
Nov 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.