Recent content by aneilh

Yes but how would i get the hotels current remaining budget? i.e. how would i calculate the total cost of each transaction?

i want want each hotel to have access to their available budget balances from every order that has taken place. Thanks

Hi, I have attached my relationships, so if you can give any help. Thanks. Please note that these relationship set up can be changed if you have any ideas. Thanks

Hello, I am using MS Access 2003 and creating a inventory management database for a Hotel Chain. However, i am a bit lost on creating a budget for each hotel in the chain, as each hotel has a bugdet of say £200,000, and each time an order takes place it must take this away. If anyone has any...