Cinema DataBase Need help with a Form.

[Tonitos]

Hello as the title says i need a Cinema Database for school i've been working on it and i don't think it's very well made.That aside when i Make a form regarding the purchase of the Ticket itself i need to be able to select a seat and mark is as Taken and this information to go trought and mark it in the other table as "Taken" so it doesn't show.Im a newbie so i need all the help i can get.I can send you the datebase if you would like.

[orange]

See this free video to show how you could handle available and taken seats on a form.

[Tonitos]

Thanks orange but this doesn't really resolve my problem

[ssanfu]

Maybe you could post your dB.... It's not very clear what your question is. We can't see your table structure nor your forms.

[Tonitos]

http://www.megafileupload.com/en/fil...mi3-accdb.html Here you go guys.Its not in English but you can get what each table is for just by openning it.

[Tonitos]

Maybe you could post your dB.... It's not very clear what your question is. We can't see your table structure nor your forms.

Just did ^^ above this reply ^^

[orange]

Free theatre data model http://databaseanswers.org/data_mode...ings/index.htm
Business rules/facts for the theatre data model at http://databaseanswers.org/data_mode...ings/facts.htm

I looked at your relationships: A few observations.

All relationships are 1:1 it seems??? Review the free data model for suggested cardinalities.
Do not use field names with embedded spaces.

Good luck with your project.

[Tonitos]

Free theatre data model http://databaseanswers.org/data_mode...ings/index.htm
Business rules/facts for the theatre data model at http://databaseanswers.org/data_mode...ings/facts.htm

I looked at your relationships: A few observations.

All relationships are 1:1 it seems??? Review the free data model for suggested cardinalities.
Do not use field names with embedded spaces.

Good luck with your project.

Yeah i saw that on google but in order to do it i have to redo the whole project so i'm trying to fix mine.I've made some corrections since i last uploaded it and i got some thing working but not everything... Still struggling with them forms.

[orange]

You start with some business facts; then build the model to support the facts; test it with test data; reconcile each and every anomaly; until the model supports all of your business facts. Then, build the database. It's like having a blueprint to build a house/airplane/shopping center.....

A form(s) may be the issue, but it's still out of context to the reader. We still don't know your business rules/facts.

[ssanfu]

I have to agree with Orange (Post # 9). Need to design on paper first, then create objects.

Yeah i saw that on google but in order to do it i have to redo the whole project so i'm trying to fix mine

Sorry, but IMO, I don't see anyway of fixing the dB. It would be better and faster to do a proper design.

In the past (long ago) I designed databases "on-the-fly" and always ended up tossing them and starting over. Now I do as Orange suggests.