This should get you a little further along in the project.
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
While reading up on things here's a link I would suggest you put on your reading list.
It felt like I was forgetting something. They say it is the second think to go.
http://www.mvps.org/access/lookupfields.htm
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