The reason I need to record everything is that another application will also be writing to the DailyActivity table
as well as getting values from the other tables.
Thanks for your help.
Maybe I should give more info on what I'm trying to do.
I have 3 tables- Badgeprofile, FMPSCode, and Prepay.
Badge profile contains: BadgeID, FirstName, LastName, FMPSCOde, and FMPSDescription.
FMPSCode table contains: FMPSCode,FMPSDescription, BreakfastCost, and LunchCost.
Prepay table...
Thank you for your response.
I don't know how to "populate the controls" from the query
I created. Any ideas would be much appreciated. I'm stuck.
I created a form from a query pulling fields from several different tables. Now I want to save this data to a table. I've tried several different methods with no luck. Any suggestions?
OK, on my form I have customer ID, customer code, meal type, and meal cost fields. When I enter in a customer ID, the customer code is filled in automatically (that's working). What I need is to display and save to the table the meal cost depending on what the customer code is and the meal...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.