database for a restaurant

[gleber]

I downloaded the db but I will be busy until tomorrow night. Sorry.

That's Ok. On your time! I'll keep reading the book for more answers.



Appreciated!

Gleber

[RuralGuy]

This should get you a little further along in the project.

[gleber]

Hi Allan,

Thank you so much for the fix. I’m trying to understand and learn what you did. So far I noticed you have created a query and added an event AfterUpdate for the [ITEM]. That’s the only way to fill up the [PRICE] or could I have it working directly on the t_LineItem? Also I notice you excluded the [SUBTOTAL] from the t_LineItem and it now appear on the query. Now I’m trying to get the query and t_LineItem to store the tiketID (it’s not happening now).
Other thing is every time I try to enter a number on the [QUANTITY] access shows me an alert w/ the message ‘The object doesn’t contain the Automation object ‘TICKET_NUM’. So after all the items are not being inserted in the table t_lineItem!
Thank you so much again for your time and help. I’ll try to not bother you anymore… I’m trying to find more answers in the Northwind database. It’s a good DB to learn more.
Best regards
Gleber

[RuralGuy]

While reading up on things here's a link I would suggest you put on your reading list.

[gleber]

While reading up on things here's a link I would suggest you put on your reading list.

Where is the link?

LOL

Thanks again Allan.

[RuralGuy]

It felt like I was forgetting something. They say it is the second think to go.
http://www.mvps.org/access/lookupfields.htm

[gleber]

Hey Allan,
Thank you for the link. It helped a lot on my project.


And thanks to your help... I did a great progress on my database. You leaded me to the right path. I don’t want to waste your time but I have attached the database for you to take a look and see how much I have improved and if you have any suggestions to make it better.


Now (as usual), new questions:


I have a Yes/No object on my f_ticket form (Free Meal?) and I need to have the discount field (txtDISCOUNT) change the value to 100% and turn it as disable once the user select a “YES”;


How can I transfer the Ticket Total value (a calculated field) to the t_Ticket table [TICKET_TOTAL]?;


And on the Ticket Total I have a calculated amount. I’m trying to get a value on the table t_tax on the formula. How can I call that table field on the formula? I have tried to insert on the expression builder as =(([fsub_LineItem].[Form]![txtTOTAL])-([txtDiscAmt]))*([t_TAX].[table]![TAX])


Or


=([fsub_LineItem].[Form]![txtTOTAL])-([txtDiscAmt])* [t_TAX]![TAX]


And all sort of variations but no success. So right now I have


=(([fsub_LineItem].[Form]![txtTOTAL])-([txtDiscAmt]))*(0.065)


6.5% Florida State Tax


As always, thanks for your time and any help, input or hint!
Best regards
Gleber